Discussion board where members can get started with QlikView.
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.
Use pivot table. Add Year as additional dimension and then drag this year dimension to column.
Yes, I know that. But I would want an Expression to do the same thing.