Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have an easy question for you guys!
How can i change the Set analys below so the field "Levförsstatistik" include the value 1 OR null?
Count({$<Levstatistik={'1'},Levförsstatistik={'1'},Levförsenad={'Ja'}>}Levförsenad)
Thanks!
Patric
Manish is right. To omit this, you can assign the value 0 in the scipt to Levforsstatistik as follows:
if(isnull(Levforsstatistik),0,Levforsstatistik) as Levforsstatistik
Now you can extend the set analysis as follows;
Count({$<Levstatistik={'1'},Levförsstatistik={'1,0'},Levförsenad={'Ja'}>}Levförsenad)
You can't select null values in QlikView set analysis
UPDATE:
You can use as below...
Count({$<Levstatistik={'1'},Levförsstatistik={'1'},Levförsenad={'Ja'}>}Levförsenad) +
Count({$<Levstatistik={'1'},Levförsstatistik={"=Len(Trim(Levförsstatistik))=0"},Levförsenad={'Ja'}>}Levförsenad)
Manish is right. To omit this, you can assign the value 0 in the scipt to Levforsstatistik as follows:
if(isnull(Levforsstatistik),0,Levforsstatistik) as Levforsstatistik
Now you can extend the set analysis as follows;
Count({$<Levstatistik={'1'},Levförsstatistik={'1,0'},Levförsenad={'Ja'}>}Levförsenad)
Thanks alot Tjeerd
A perfect solution for me, nice and clean!
Patric
There is another solution, I'd like to share, look at this example.