Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Highlighted
prathipsrinivas
New Contributor III

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
New Contributor III

Re: Dynamic Expressions in Pivot table

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

 

Thanks Anyways

Community Browser