Discussion Board for collaboration related to QlikView App Development.
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!
View solution in original post
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 ??)
I figured it out. thanks again!
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.
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: