topic Re: Set analysis not working inside IF in QlikView

Set analysis not working inside IF

martynlloyd — Mon, 15 Jun 2015 14:55:44 GMT

Hi Everyone,

I have a dimension "Dimension" with 4 values:

Units

Registrations

TY v LY

If I have an expression: Sum({$<Dimension={'Units','Registrations','Share'}>} Measure)

- that works fine

I want a different format for the Share, so I use:

If (Dimension='Share', Num(Sum({$<Dimension={'Units','Registrations','Share'}>} Measure),'##0.0%'),Sum({$<Dimension={'Units','Registrations','Share'}>} Measure))

So now I get ALL 4 values - the set analysis is ignored.

Why?

best regards,

Marty.

Re: Set analysis not working inside IF

robert_mika — Mon, 15 Jun 2015 16:03:02 GMT

No sure but the only difference between the False-and true is the format.

So if the Dimension is Share you will get % otherwise get Expression format.

Could you post your data or screenshot?

Re: Set analysis not working inside IF

martynlloyd — Mon, 15 Jun 2015 16:54:37 GMT

Screenshots

Re: Set analysis not working inside IF

sunny_talwar — Mon, 15 Jun 2015 16:57:01 GMT

Make sure Suppress Zero-Values on Presentation tab is checked:

Re: Set analysis not working inside IF

martynlloyd — Mon, 15 Jun 2015 17:27:09 GMT

Thanks!

I'm trying to do two incompatible things at the same time - I'll have to solve that in the script...

Marty.

Re: Set analysis not working inside IF

sunny_talwar — Mon, 15 Jun 2015 17:30:29 GMT

Or try using a calculated dimension for one of them and suppress is from there.

If(Match(Dimension, 'Units', 'Registrations', 'Shares'), Dimension)

and select "Suppress When Value Is Null" option on the Dimensions tab. and then you won't have to worry about z15 v 14 and you will be able to uncheck Suppress Zero Values on presentation tab.

HTH

Best,

Sunny