Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

request

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

2 Replies
giakoum
Honored Contributor II

Re: request

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

Re: request

Hi,

one solution could be:

QlikCommunity_Thread_142188_Pic1.JPG.jpg

hope this helps

regards

Marco

Community Browser