topic Aggregate dimension in QlikView

Aggregate dimension

Fri, 23 Aug 2013 09:02:13 GMT

Hi,

I was wondering if it is possible to achieve the following.

I tried using the following formula, but I did not work...

aggr(sum({$<[Employee]={'TR','DB','EFR','NVP','ERB','WV','LC'}>}

[Job Duration Minutes]),

[Employee],[ID])

Thanks!

Maarten

Re: Aggregate dimension

Gysbert_Wassenaar — Fri, 23 Aug 2013 09:09:03 GMT

Hi Maarten,

I think it's possible. You'll probably have to use the total modifier keyword in the sum expression. Note, you would have the value 525 displayed on two rows. The cells of the two rows involved won't be merged. Can you post an example document? See: Preparing examples for Upload - Reduction and Data Scrambling

regards,

Gysbert

Re: Aggregate dimension

Fri, 23 Aug 2013 09:54:23 GMT

Dear Gysbert,

Thanks a lot for your quick reply.

Is there any chance that the two cells can be merged in some way?

I don't want to end up with two cells displaying 525 (giving the impression that in total for a certain project id 1050 minutes have been logged).

For what concerns uploading the cloud: I'm affraid my employer will not be happy when putting the cloud online (even with scrambling) but I can isolate the problem in a new cloud if that would help.

Kind regards,

Maarten

Re: Aggregate dimension

Gysbert_Wassenaar — Fri, 23 Aug 2013 10:00:43 GMT

No, it's not possible to merge cells. You could try creating a calculated dimension. That would behave like other dimensions in a pivot table and show merged cells. It would however be displayed as a column left of the expression columns like the other dimensions. Qlikview is not a spreadsheet program so it doesn't support all the fancy cell based trickery that Excel allows you.