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: 
ali_hijazi
Partner - Master II
Partner - Master II

Group Expressions under labels

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)

I can walk on water when it freezes
5 Replies
clisboa_noesis
Partner - Creator
Partner - Creator

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

ali_hijazi
Partner - Master II
Partner - Master II
Author

can u please elaborate ur idea or send me sample document?

I can walk on water when it freezes
Not applicable

Interested too

natebrunner
Contributor III
Contributor III

Also interested if you have an example.

clisboa_noesis
Partner - Creator
Partner - Creator

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