topic Re: Hide Row when two values are 0 in QlikView

Hide Row when two values are 0

Thu, 02 Aug 2012 08:59:19 GMT

Hi There,

I have a pivot chart that has about 12 calcuation fields on it.

I'd like to hide the rows if both of two caculations = 0 even if the other fields return values.

Can i do it without putting that test in each of the other 10 calcs?

Thanks

Jason_Michaelides — Thu, 02 Aug 2012 09:02:31 GMT

You could try wrapping it in Aggr() and putting it in the dimension? Or use Dimension Limits if you're on v11.

Mon, 06 Aug 2012 07:46:57 GMT

Thanks that did work using Aggr().

senpradip007 — Mon, 06 Aug 2012 07:53:43 GMT

You could use Dimension Limits if you're on v11.