Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I am new to qlikview.Could someone please help in understanding the concept of (no concatenate + not exists function) as in above output I m able to see that the count of name'Naman' is not correct but when I remove no concatenate word from script count comes corrects. How this is happening.
Could someone please explain why id2 '10' and field name2 'naman' count is coming 1 instead of 2 by using exists and no concatenate statement in between two table loads.
Message was edited by: namrata maheshwari
Hi Namrata,
Let's take it one step at a time.
If you take away the NoConcatentate, but leave the not exists, this will combine temp2 and temp3, appending any new values
Hope this helps.
Lisa