Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
prathipsrinivas
Creator
Creator

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 

Prathip
Labels (2)
2 Replies
tresesco
MVP
MVP

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

prathipsrinivas
Creator
Creator
Author

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

 

Thanks Anyways

Prathip