Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

prathipsrinivas
Contributor

Dynamic Expressions in Pivot table

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 

2 Replies
MVP
MVP

Re: Dynamic Expressions in Pivot table

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

prathipsrinivas
Contributor

Re: Dynamic Expressions in Pivot table

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

 

Thanks Anyways