Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear I got a pivot table with 6 expressions
the first 3 refer to calculation of Month To Date of Actuals and Budgets
the rest refer to the calculation of Year To Date of Actual and Budgets
Check Figure one (Attached)
Is there a way to group these as in figure 2? (Attached)
Hi ali_hijazi,
I believe all you need to do is add an calculated dimension with ValueList and pull that dimension to the top.
The expressions need to be changed like this:
if(ValueList('MTD','YTD') = 'MTD',
...
)
So that the expression is put in the right place.
Regards,
Carlos
can u please elaborate ur idea or send me sample document?
Interested too
Also interested if you have an example.
Hi,
Sorry for the late reply, got lost in my inbox
I've attached an example here: http://community.qlik.com/servlet/JiveServlet/downloadBody/3201-102-1-3418/GroupExpressions.qvw
Hope it helps.
Regards,
Carlos