Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis return 0 value even if there is no value

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?



1 Reply

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() )