topic Re: Set analys question in QlikView

Set analys question

Anonymous — Fri, 28 Mar 2014 07:51:35 GMT

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

Re: Set analys question

MK_QSL — Fri, 28 Mar 2014 07:55:54 GMT

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)

Re: Set analys question

tabletuner — Fri, 28 Mar 2014 08:15:25 GMT

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)

Re: Set analys question

Anonymous — Fri, 28 Mar 2014 08:54:14 GMT

Thanks alot Tjeerd

A perfect solution for me, nice and clean!

Patric

Re: Set analys question

alexandros17 — Fri, 28 Mar 2014 09:07:28 GMT

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