Discussion Board for collaboration on QlikView Layout & Visualizations.
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
field_2 is your dimension
count(field_1) is your expression
but you need to add set analysis for the where part :
if this does not work, you need to substitute the null value with a default one while loading.
Question on including NULL in SET Analysis
one solution could be:
hope this helps