topic Group Expressions under labels in QlikView

Group Expressions under labels

ali_hijazi — Fri, 04 May 2012 12:02:52 GMT

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)

clisboa_noesis — Fri, 04 May 2012 12:14:50 GMT

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 — Fri, 04 May 2012 20:03:12 GMT

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

Wed, 23 May 2012 13:37:11 GMT

Interested too

natebrunner — Wed, 18 Jul 2012 14:25:26 GMT

Also interested if you have an example.

clisboa_noesis — Wed, 18 Jul 2012 14:46:58 GMT

Hi,

Sorry for the late reply, got lost in my inbox

Hope it helps.

Regards,

Carlos