topic request in QlikView

request

Fri, 14 Nov 2014 13:47:05 GMT

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 — Fri, 14 Nov 2014 13:53:19 GMT

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.

MarcoWedel — Fri, 14 Nov 2014 22:34:30 GMT

Hi,

one solution could be:

hope this helps

regards

Marco