topic Re: If to set analysis in QlikView

If to set analysis

rdsuperlike — Tue, 10 May 2016 21:08:54 GMT

I have below statement:

count(distinct if([Test Result Code] <> ' ' AND [Test Result Code] <> null(),[Serial Number]))

Below set analysis looks correct ?

count(distinct{$<[Test Result Code] -= {' ',null}>} [Serial Number] )

the xpression shows ok but it gives those red line...so not sure

swuehl — Tue, 10 May 2016 21:11:32 GMT

NULL is not a value, but maybe like

count(distinct{$<[Test Result Code] = {"=Len(Trim([Test Result Code]))>0"}>} [Serial Number] )

sunny_talwar — Tue, 10 May 2016 21:16:53 GMT

May be this:

Count(DISTINCT {$<[Serial Number] = {"=Len(Trim([Test Result Code])) > 0"}>} [Serial Number])