Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Thanks Anyways