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

[wizardo]

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

[tresesco · Accepted solution]

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.

[wizardo]

my mistake