Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Karthiek22
Contributor
Contributor

Display only one sale report in bar chart

I have sales like 10, 20, 30. If I want to show only 20 sales in a bar chart what's the expression.

2 Solutions

Accepted Solutions
jmartineze
Partner - Creator
Partner - Creator

Hello, 

look for information about set analysis.

sum({<field={20}>}Sales)

View solution in original post

Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Is your sales column a dimension or measurement?

If it is a dimension:

sum({<Sales={'20'}>}   [Your Measurement] )

 

View solution in original post

3 Replies
jmartineze
Partner - Creator
Partner - Creator

Hello, 

look for information about set analysis.

sum({<field={20}>}Sales)

Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Is your sales column a dimension or measurement?

If it is a dimension:

sum({<Sales={'20'}>}   [Your Measurement] )

 

Karthiek22
Contributor
Contributor
Author

Sales column is a dimension. It's worked out. 

Thanks bro