Dynamic lables in pivot table

Wed, 27 Jul 2011 08:55:24 GMT

Hi,

In my pivot table, I need to show data for today, last month end, last quarter end.

My requirement is that, I wish to show lables as LastMonthEnd <date on last monthend>.

I tried using expression for lable as: 'Prior Quarter End' & =DATE(QuarterEnd(max(Date),-1), 'YYYY-MM-DD')

But it is not working.

However if I use expression as: =DATE(QuarterEnd(max(Date),-1), 'YYYY-MM-DD') & 'Prior Quarter End' then it works.

But I wish to dispaly text 'Prior quarter end' first and then contactinated with date.

Please guide me how to achive it.

Wed, 27 Jul 2011 09:24:25 GMT

Rohit,

Try this out. Problem with your code was "=" sign was misplaced near date. "=" sign should be always at the starting of the expression.

='Prior Quarter End' & DATE(QuarterEnd(max(Date),-1), 'YYYY-MM-DD').

-Sridhar

topic Dynamic lables in pivot table in QlikView