Discussion Board for collaboration on QlikView Layout & Visualizations.
I have a table which display CY and LY sales and i also have a 3 col which display the sales change %.
Now i like to make my table only list those sales up customer.
Hope some one can advise how to achieve this ?
Go to Solution.
So you don't want to display any -ve % values?
So that sales person can take action on those sales increase customer. So that sales can further increase. And still want to view the % up.
Sent from Samsung Mobile
Use % increase as your first expression and use dimension limits by first expression.
Thank you very much. Can you pls give me some example ?
Yes this is what i need. But i am not able to figure out how you do it. can you share with me ?
Phaneendra Provide me a soluition , which is very good. but i am not sure how he filter only display +Ve % value , can some one tell me ?
I think he changed your expressions to only calculate when sales for the current period are more than the sales for the previous period. Take a look at your expressions. Hope that helps.
He very smart.