topic Pivot Table in QlikView

Pivot Table

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

good afternoon

They could help??

Can you use an expression as dimension in a pivot table?

Thank you

Re: Pivot Table

sunny_talwar — Wed, 07 Dec 2016 19:03:34 GMT

You can, you just need to use either Aggr() function or Total qualifier with it for it to work properly

Re: Pivot Table

Anonymous — Wed, 07 Dec 2016 22:18:06 GMT

Sunny T

good afternoon

Is there any other way to do it other than the Agrr function

Re: Pivot Table

Anil_Babu_Samineni — Thu, 08 Dec 2016 01:29:46 GMT

Might be other ways possible, Would you let us know what was the expression you want to as Dimension. So that, We can open other ways too for you that Agenda

Re: Pivot Table

sunny_talwar — Thu, 08 Dec 2016 03:01:07 GMT

Can you provide a sample to help you better?

Re: Pivot Table

dineshm030 — Thu, 08 Dec 2016 04:56:01 GMT

Can you send the sample QVW file?

Re: Pivot Table

Anonymous — Thu, 08 Dec 2016 06:42:43 GMT

Hi,

Yes you can add expression as dimension with aggr() function, u will require to aggregate ur expression against some given dimensions.

Thanks,

Re: Pivot Table

Anonymous — Fri, 09 Dec 2016 17:55:20 GMT

Good afternoon

this is the expression that I need to use as dimension

SUM(PACTADO_INICIAL)

Thank you