topic Re: Aggregate Dimensions in QlikView

Aggregate Dimensions

Wed, 31 Jul 2013 06:38:14 GMT

Hi Everybody,

I want to aggregate the values of a dimension in the following way:

The dimension "item group" has 4 digits with a revenue

- BYDF ==> 100.000€

- BYRK ==> 200.000€

- BYSW ==> 250.000€

What I want to do is aggregate the revenues of these three values to a single-digit item group "B", which sums up the values to 550.000€. "B" should be displayed within the other 4-digit item groups as a dimension.

Thanks for any ideas.

Re: Aggregate Dimensions

sivarajs — Wed, 31 Jul 2013 08:16:49 GMT

Add a calculated dimension as if(Group='BYDF','B',if(Group='BYRK','B',if(Group='BYSW','B'))) or

if(WildMatch(Group,'B*'),'B')

Expression as sum(amount)

Re: Aggregate Dimensions

Wed, 31 Jul 2013 08:33:08 GMT

Hey,

thanks for your quick answer. I already thought about the cascadef if-statement, but it's not the right way. The result should look like this:

- B ==> 550.000€ (the calculated sum of the 3 revenues below)

- BYDF ==> 100.000€

- BYRK ==> 200.000€

- BYSW ==> 250.000€

Best regards

Re: Aggregate Dimensions

Wed, 31 Jul 2013 09:02:49 GMT

I think, you can solve this by using WildMatch function. See the attachment.

Re: Aggregate Dimensions

Wed, 31 Jul 2013 09:10:50 GMT

We are on the right way 🙂 The aggregation works, but I need to display the other 3 four-digit item groups.

Re: Aggregate Dimensions

Wed, 31 Jul 2013 09:47:25 GMT

Hi,

I am not able to solve this from chart object level. So, I have made it through the script. Pelase see the attachment.

Re: Aggregate Dimensions

Wed, 31 Jul 2013 11:01:23 GMT

Perfect. Thank you very much!!!