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: 
skompel2
Contributor II
Contributor II

Combine multiple values in a dimension in Chart Box

I have the below table. I'm trying to create a pivot table (second table below) such that the locations "TR02,TR03,TR04" are pooled/aggregated in a single cell and renamed as "incomplete". Similarly location "SD" pooled and renamed as "finished". Then i can create a bar chart using this table as a filter so that it shows sum of completed qty for both "incomplete" and "finished" categories.

I used MATCH,AGGR,SET ANALYSIS and IF statements in calculated dimensions/Expressions tab for chart properties but they don't work. Please help me as it's driving me crazy.

 

product codelocationQty
EngineSD1
ShaftTR0210
PumpTR031
Shaft TR040
ShaftTR031
PumpTR031
EngineSD10

  

product codelocationQty
Enginefinished11
Transmissionincomplete11
Pumpincomplete2
1 Solution

Accepted Solutions
sunny_talwar

This should work

Dimension

[product code]

If(location = 'SD', 'finished', 'incomplete')

Expression

Sum(Qty)

View solution in original post

3 Replies
sunny_talwar

This should work

Dimension

[product code]

If(location = 'SD', 'finished', 'incomplete')

Expression

Sum(Qty)
skompel2
Contributor II
Contributor II
Author

Thank you Mr. sunny. I've another question for you:

what is the difference between "Add Calculated dimension" , "Edit" dimension and "Enable Conditional check box" options in dimensions?

In the answer you have given, i assume i have to use "Add calculated dimension" for IF statement?

sunny_talwar

Add Calculated dimension

Add a new dimension or calculated dimension

Edit dimension

Edit an existing dimension or calculated dimension

Enable Conditional check box

Display dimension or calculated dimension only when a certain condition is met.