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

[#1]

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

[Anonymous · Accepted solution]

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)

[#3]

Thnak you very much Johannes.

[#4]

Thank you very much Johannes

Appreciate your time.