Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to filter only sales change are more then 0% ?

Hi All

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 ?

1 Solution

Accepted Solutions
phaneendra_kunc
Partner - Specialist III
Partner - Specialist III

9 Replies
phaneendra_kunc
Partner - Specialist III
Partner - Specialist III

So you don't want to display any -ve % values?

Not applicable
Author

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

iktrayanov
Creator III
Creator III

Use % increase as your first expression and use dimension limits by first expression.

phaneendra_kunc
Partner - Specialist III
Partner - Specialist III

See attached.

Not applicable
Author

Hi sir

Thank you very much. Can you pls give me some example ?

Sent from Samsung Mobile

Not applicable
Author

Hi sir

Yes this is what i need. But i am not able to figure out how you do it. can you share with me ?

Paul

Not applicable
Author

Hi All

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 ?

iktrayanov
Creator III
Creator III

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.

Not applicable
Author

hI iVAN

He very smart.