Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Bar Chart expression (not calculated)

Hi,

I have a set of calculated data which I would like to show them on chart. Column A contains Business functions and column B contains all weekly sales, Column C contains Regions. I want to write a chart expression that selects column A = 'Consumer' and displays all weekly sales from column B. The Dimension will be Regions.


Thanks in advance.


Jasmine

1 Solution

Accepted Solutions
brindlogcool
Creator III
Creator III

If i understand the requirement correctly you can use column A ,Column C in the dimension and the sales in the expression.

View solution in original post

8 Replies
brindlogcool
Creator III
Creator III

If i understand the requirement correctly you can use column A ,Column C in the dimension and the sales in the expression.

View solution in original post

iktrayanov
Creator III
Creator III

In your chart use

Dimension >>>  Regions

Expression >>>> Sum({<A = {Consumer}>}sales)

Not applicable
Author

Hi,

Thank you for your response. I want to see if I'm able to make the selection (Column A = 'Consumer') in the expression.

Jasmine

Not applicable
Author

I don't want to get Sum of the Sales because I want to display as it is.


Thanks,

Jasmine

iktrayanov
Creator III
Creator III

It will display sales per Region

iktrayanov
Creator III
Creator III

If you want to show details don't use chart just use table box.

brindlogcool
Creator III
Creator III

As Ivan suggested you can display the data in table. Or you have pass the selection in expression.

Not applicable
Author

Thank you so much for quick responses.


Jasmine