Hiding rows based on condition

[yashcena]

Hi,

I have the following data:

I have an inline table with percentages (15,20,25…..)

Requirement is whenever a user selects a percentage x, the discount amounts which were greater than x% from previous month should be highlighted.

Something like this:

The yellow highlighted rows are the ones where the discount amount was >15% from previous month.

I only want to show the months which are highlighted and not all the months.

Ex.: For the code 3T6571 I should see only  43221,43374 and 43435 months as the amount was greater than 15% from previous month for only those three months. 

Is this possible? I have attached the sample app here.

Thanks in advance!

Yash

[Vengatesh · Accepted solution]

Like this

[yashcena]

Hi..thanks for the reply. Can you tell me what and where did you make the change? I'm not able to figure out. 

(supress zero values ??)

[yashcena]

I figured it out. thanks again!

[yashcena]

Hi,

Can you tell me how to sort the expression in descending order? The highest amount should be displayed first.

I tried different expressions in 'Sort' properties but the numbers weren't getting sorted.

[Brett_Bleess]

Found the following post that has something that may work based upon my own test, and I am including a screenshot of the property to which is being referred as well, hopefully this will do the trick:

https://community.qlik.com/t5/QlikView-App-Development/Sort-Pivot-Table-on-Expression/m-p/806734#M28...

Regards,
Brett