Set Analysis return 0 value even if there is no value

Sun, 02 Aug 2015 23:13:02 GMT

Hi all,

I have an expression with set analysis and it works perfectly fine: The set check the calendar and return the latest value according to the selections.

The issue start when I move my calendar to a period in the past where there are no value for that metric. It should return me a null but it return me a 0.

Summarizing the expression go against a non existing record and return a 0 instead of a null.

Can you help me with this?

tks,

Re: Set Analysis return 0 value even if there is no value

swuehl — Mon, 03 Aug 2015 17:07:57 GMT

I believe this is QV standard behaviour and I personally don't see anything wrong with it.

If you absolutely want NULL returned, you might be able to check the number of records, like

=if( Count( {<SetExpression>} ID), Sum({<SetExpression>} IDValue), NULL() )

topic Re: Set Analysis return 0 value even if there is no value in QlikView

Set Analysis return 0 value even if there is no value

Re: Set Analysis return 0 value even if there is no value