Total include missing values

santhosh_k_n — Fri, 23 May 2014 06:43:40 GMT

Hi Team,

I am having a table as follows

Model	Header1	Header2	Header3
Mod1
Mod2	0	1	1
Mod3
Mod4	1	1	1
Mod5	1	0	1
Mod6	0	0	1
Mod7	1	1	1
Mod8	1	1	1
Mod9	0	0	1
Mod10	1	0	0
Mod11	0	0	0
Mod12
Mod13	1	1	1

In above table there are model with null values in all other fileds.

In QV i need to represent as if(isnull(Header1)=0 or isnull(Header2)=0 or isnull(Header3)=0,Model) which is working fine by supressing the null values and showing 10 models of 13.

but my requirement is to present model as above expression and total for all 13 values

Please guide me

topic Total include missing values in QlikView

Total include missing values