topic Re: Combine multiple values in a dimension in Chart Box in QlikView

Combine multiple values in a dimension in Chart Box

skompel2 — Sat, 16 Nov 2024 04:45:08 GMT

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 code	location	Qty
Engine	SD	1
Shaft	TR02	10
Pump	TR03	1
Shaft	TR04	0
Shaft	TR03	1
Pump	TR03	1
Engine	SD	10

product code	location	Qty
Engine	finished	11
Transmission	incomplete	11
Pump	incomplete	2

Re: Combine multiple values in a dimension in Chart Box

sunny_talwar — Wed, 16 Jan 2019 01:04:56 GMT

This should work

Dimension

[product code]

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

Expression

Sum(Qty)

Re: Combine multiple values in a dimension in Chart Box

skompel2 — Wed, 16 Jan 2019 01:57:08 GMT

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?

Re: Combine multiple values in a dimension in Chart Box

sunny_talwar — Wed, 16 Jan 2019 12:07:38 GMT

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.