Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Silver
Contributor
Contributor

How to create a chart that only shows the data higher than a certain number in Qlik Sense?

Hey everyone, 

Im very new to Qlik and am not sure how to solve this.

I need to show the the products that have a margin higher than 40%.

I have the products, sales, costs and Margin as data.

Can somebody help me solve this?

Labels (1)
1 Solution

Accepted Solutions
canerkan
Partner - Creator III
Partner - Creator III

Hi Silver,

you can do that by the Limitation Option in your Visualization. Check the screenshots attached. I don't know if your margin data is in percent. If not, you might need to calculate it in your load script.

You can watch this video to see how to use this option:

Dimension Limits

Let me know if it helped.

Regards,

Can

View solution in original post

2 Replies
canerkan
Partner - Creator III
Partner - Creator III

Hi Silver,

you can do that by the Limitation Option in your Visualization. Check the screenshots attached. I don't know if your margin data is in percent. If not, you might need to calculate it in your load script.

You can watch this video to see how to use this option:

Dimension Limits

Let me know if it helped.

Regards,

Can

Silver
Contributor
Contributor
Author

Yes it worked! thank you