Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
yashcena
New Contributor II

Hiding rows based on condition

Hi,

I have the following data:

eew.JPG

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:

Capture2.JPG

 

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. 

Capture12.JPG

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

 

Thanks in advance!

Yash

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Hiding rows based on condition

Like this

You Know What To Do.

View solution in original post

5 Replies
Highlighted
Partner
Partner

Re: Hiding rows based on condition

Like this

You Know What To Do.

View solution in original post

Highlighted
yashcena
New Contributor II

Re: Hiding rows based on condition

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

Highlighted
yashcena
New Contributor II

Re: Hiding rows based on condition

I figured it out. thanks again!

Highlighted
yashcena
New Contributor II

Re: Hiding rows based on condition

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.

Highlighted
Digital Support
Digital Support

Re: Hiding rows based on condition

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

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.