Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Qlik experts,
I have a question regarding Set Analysis. I know it might be possible to handle this more elegantly in the backend, but I still want to improve my Set Analysis skills.
Here's my scenario: I want to exclude certain values from a field, but I also want to include the null values. How can I structure the following query correctly without filling the null values with a specific value in the data editor?
I have tried: COUNT({<BelegArt={'U'}, Herk_BelegArt-={'A'}>}ID), but this doesnt work.
Best regards Son
NULLs are not selectable, so you cannot use them in a set expresion.
But you can try using the E() function to select the right IDs, something like
Count({<BelegArt={'U'},ID=E({<Herk_BelegArt={'A'}>} ID)>} ID)
See also https://community.qlik.com/t5/Design/Excluding-values-in-Set-Analysis/ba-p/1471704.
NULLCOUNT({<BelegArt = {'U'}>}Herk_BelegArt) + COUNT({<BelegArt={'U'}, Herk_BelegArt-={'A'}>}ID)
NULLs are not selectable, so you cannot use them in a set expresion.
But you can try using the E() function to select the right IDs, something like
Count({<BelegArt={'U'},ID=E({<Herk_BelegArt={'A'}>} ID)>} ID)
See also https://community.qlik.com/t5/Design/Excluding-values-in-Set-Analysis/ba-p/1471704.
Thank you for your input. This solution is almost perfect, but in my opinion, HIC's solution is more elegant.