Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

Re: Display only one sale report in bar chart

Hello, 

look for information about set analysis.

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

View solution in original post

Highlighted
Partner
Partner

Re: Display only one sale report in bar chart

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
Highlighted
Partner
Partner

Re: Display only one sale report in bar chart

Hello, 

look for information about set analysis.

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

View solution in original post

Highlighted
Partner
Partner

Re: Display only one sale report in bar chart

Is your sales column a dimension or measurement?

If it is a dimension:

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

 

View solution in original post

Highlighted
Contributor
Contributor

Re: Display only one sale report in bar chart

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

Thanks bro