topic Re: How to supress rows in Pivot table depending on expression value? in QlikView

How to supress rows in Pivot table depending on expression value?

Fri, 12 Oct 2012 17:50:26 GMT

Greetings Qlikview Experts....

I am new to Qlikview and appreciate your help.

I am using Qlikview version 9.0

Oracle Database 11

I have a requirement where i need to suppress rows depending on an expression value, if the expression value is greater than or equal to input value(stored as variable).

I do have several other expression before and after this one but the value of this expression is

Expression: =(sum({<YEARQUARTER={$(=Max(YEARQUARTER))}>} (ZIPDIST/1000) * CALCRATE)/13)/ZIPDIST

This expression is working asis and able sort on this expression aswell but not sure how to supress rows.

I will need suppress rows logic =((sum({<YEARQUARTER={$(=Max(YEARQUARTER))}>} (ZIPDIST/1000) * CALCRATE)/13)/ZIPDIST) >= InputVarValue.

Appreciate your time.

Thank you,

Pad

Re: How to supress rows in Pivot table depending on expression value?

Anonymous — Mon, 15 Oct 2012 04:41:40 GMT

Set the dimension to suppress null values and then create an if() statement for your expression to set it to null if it is within your cut off logic.

If(CALCULATION >= InputVarValue,null(), CALCULATION)

Re: How to supress rows in Pivot table depending on expression value?

Mon, 15 Oct 2012 13:11:12 GMT

Thnak you very much Johannes.

Re: How to supress rows in Pivot table depending on expression value?

Mon, 15 Oct 2012 13:12:27 GMT

Thank you very much Johannes

Appreciate your time.