Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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.