Set analys question

[Anonymous]

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

[MK_QSL]

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)

[tabletuner · Accepted solution]

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)

[Anonymous]

Thanks alot Tjeerd

A perfect solution for me, nice and clean!

Patric

[alexandros17]

There is another solution, I'd like to share, look at this example.