topic Re: Hiding rows based on condition in QlikView

Hiding rows based on condition

yashcena — Sat, 16 Nov 2024 20:43:00 GMT

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

Re: Hiding rows based on condition

Vengatesh — Thu, 06 Jun 2019 09:58:09 GMT

Like this

Re: Hiding rows based on condition

yashcena — Thu, 06 Jun 2019 10:04:55 GMT

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 ??)

Re: Hiding rows based on condition

yashcena — Thu, 06 Jun 2019 10:14:37 GMT

I figured it out. thanks again!

Re: Hiding rows based on condition

yashcena — Fri, 07 Jun 2019 10:56:33 GMT

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.

Re: Hiding rows based on condition

Brett_Bleess — Tue, 09 Jul 2019 21:33:05 GMT

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#M284795

Regards,
Brett