topic help with set analysis and a conditional in QlikView

help with set analysis and a conditional

Tue, 11 Nov 2014 18:29:08 GMT

I have to calculate the SUM(quantity1) - sum(quantity2) but without considering the field MONTH.

And in the other hand, if this expresion (SUM(quantity1) - sum(quantity2)) is <=0 i don't wanna see it.

I think i did the first part what what i have to do to have that conditional?

Thank you all

Greetings.

Re: help with set analysis and a conditional

Tue, 11 Nov 2014 18:33:47 GMT

if((SUM(quantity1) - sum(quantity2)) is >=1,1,0) write this in layout tab.

sum(quantity1)-sum(quantity2) without cosidering month field means what?

Re: help with set analysis and a conditional

Anonymous — Tue, 11 Nov 2014 18:37:02 GMT

If (SUM({<Month=>}quantity1) - sum({<Month=>}quantity2) < 0 , null(), SUM({<Month=>}quantity1) - sum({<Month=>}quantity2))

Re: help with set analysis and a conditional

JonnyPoole — Tue, 11 Nov 2014 19:18:31 GMT

With additions it may not make any difference to do it in one expression

if( SUM( {$<MonthFieldName=>} quantity1- (quantity2)) >= 0 , SUM( {$<MonthFieldName=>} quantity1- (quantity2)) )

By not defining the ELSE condition it defaults to NULL and by default if you use this in a chart, the default setting on the presentation tab of the chart properties is to suppress nulls.

This will suppressing aggregates (by dimensional value) that are negative .