request

[#1]

hi

i want to execute this request in qlikview in a list of selection:

select count(field_1) from tabname where field_2='var' and field_3=null

group by field_2

[giakoum]

field_2 is your dimension

count(field_1) is your expression

but you need to add set analysis for the where part :

<{field_2={"var"}, field_3={""}>}

if this does not work, you need to substitute the null value with a default one while loading.

OR

Question on including NULL in SET Analysis

[MarcoWedel]

Hi,

one solution could be:

hope this helps

regards

Marco