Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to count NULL values using Set Analysis. I basically use this code:
Count({$<[EagleFeedback.Win/Loss]={}>} [EagleFeedback.Win/Loss])
It never returns any values even though I know there are some.
How do I use Set Analysis to count NULL values?
How about:
SUM(-ISNULL([EagleFeedback.Win/Loss]))
I was having the same problem and this is what I ended up with. Set Analysis is very finicky about null values.
Hope this helps anyone else.
If your EagleFeedback.Win/Loss carries only 'Win', 'Loss' or NULL values, try this:
Count({$-1<[EagleFeedback.Win/Loss]={'Win','Loss'}>} [EagleFeedback.Win/Loss])
You can Try :
Count({[EagleFeedback.Win/Loss]-={'*'}>} [EagleFeedback.Win/Loss) (or -={*})
You can use:
count({$<Customer={"=isnull(Address)"}>} Customer)
In this link i found the solution, it worked for me.
How to handle NULL values, ANDs and ORs in SET ANALYSIS: | QlikView Help, Tips & Hints
Hi Dave,
what is the origin of your data ?
DB or Load ?
Hi,
in my experience I can tell you that probably the only option with set analysis that will work for you is similar to what the blog suggested by Eugenio says:
Count({1 - <[EagleFeedback.Win/Loss]={'*'}>} [EagleFeedback.Win/Loss])
Otherwise, you can use NULLASVALUE in script in order to assign a string/numeric default value for nulls:
NULLASVALUE [EagleFeedback.Win/Loss];
Set NullValue = 'N/A';
regards