topic Re: how to return 0 (zero) when set analysis expression not fulfilled in QlikView

how to return 0 (zero) when set analysis expression not fulfilled

wizardo — Tue, 09 Oct 2018 10:15:53 GMT

hi,

let's say i have a set analysis expression like this

sum( {<Year={2015}>} sales)

and there is no year 2015 in the data

the expression is calculated and returns sales for all the years

my question is

is it possible to make it return 0 (zero) instead?

or do I have to use IF

thanks

Re: how to return 0 (zero) when set analysis expression not fulfilled

tresB — Tue, 09 Oct 2018 10:20:30 GMT

DANIEL CHOTZEN wrote:

hi,

let's say i have a set analysis expression like this

sum( {<Year={2015}>} sales)

and there is no year 2015 in the data

the expression is calculated and returns sales for all the years

my question is

is it possible to make it return 0 (zero) instead?

or do I have to use IF

thanks

This is not correct. Qlik returns 0 (zero).

Could you share a sample where the behavior (as you explained) could be noticed? I can think of one possibility - your field reference might be being wrong, i.e. - may be, by mistake you are typing a wrong field name in set analysis.

Re: how to return 0 (zero) when set analysis expression not fulfilled

wizardo — Tue, 09 Oct 2018 10:33:27 GMT

my mistake