I have some values(lets say red, blue, green, orange, black, yellow, (blank) ) in column A.
How can I load column A with only red, blue, and yellow?
I am able to do
if(A<> red, A)
How can I add multiple values and add the blank as well?
Thank you in advance
(Don't have access to "Discussion Forums")
Solved! Go to Solution.
Hello Cedric - as in: ?
(biff, embedded labels, table is SalesData$)
Cedric / Gabriel - did you get Match() =0; to work? - If so in what context?
Simply using match() = 0; does not work for me.
I got this to work for the opposite values, and my blank data seems to be excluded by default.
Thanks - just curious.
Hi Cedric - BTW one note - please take a look at this post to see how QlikView / Qlik Sense handles NULLS, <blank>, NOTHING - because they are not always created equally. I want to make sure your test case is accurate.