topic Re: Dynamic Expressions in Pivot table in QlikView

Dynamic Expressions in Pivot table

prathipsrinivas — Sat, 16 Nov 2024 04:54:16 GMT

Hi Qlikers,

I have a requirement where in I need to show year wise sales in Pivot table or straight table.

I don't want to write many expressions (one expression for one year) but I want to write only one expression which has to show as many columns as no of distinct years.

Is this possible? Any leads or ideas would be highly appreciated.

Thanks,

Prathip

Re: Dynamic Expressions in Pivot table

tresB — Mon, 24 Dec 2018 07:49:03 GMT

Use pivot table. Add Year as additional dimension and then drag this year dimension to column.

Re: Dynamic Expressions in Pivot table

prathipsrinivas — Mon, 24 Dec 2018 12:02:25 GMT

Yes, I know that. But I would want an Expression to do the same thing.

Thanks Anyways