Dimension Values as a Pivot Expression Heading

[ajithsachin]

HI All,

     I need to get the dimension values as a expression heading in a Pivot table.

     Below i am giving my table structure.

MonthYear	Sales	LastyearMonthSales	LastYearMonth
Apr-14	15	10	Apr-13
May-14	25	28	May-13
Jun-14	18	17	Jun-13

and made a Pivot table like this

Apr-15		May-15		Jun-15
Sales	LastyearMonthSales	Sales	LastyearMonthSales	Sales	LastyearMonthSales
15	10	25	28	18	17

in this pivot my second expression is LastyearMonthSales, Along with this heading i need to concatenate LastYearMonth value.

So my table will look like this.

Apr-15		May-15		Jun-15
Sales	LastyearMonthSales-Apr-2013	Sales	LastyearMonthSales-May-2013	Sales	LastyearMonthSales_Jun-2013
15	10	25	28	18	17

Please suggest how to do this.

Regards,

Ajith

[jagan]

Hi Ajith,

It is not possible in Qlikview, the Expression labels are based on the chart level, but not on the basis of Dimensional values.  If you want like this then you have to manually create 6 expressions, 3 for sales, and three for LastYearMonthSales with Month name.

Regards,

Jagan.

[its_anandrjs]

With pivot table not possible.

[ajithsachin]

Hi,

     Thanks for your reply.    

     I have so many expressions based on a particular Month And Year like Sales,Target,Growth,Ach% etc

     and in that two columns are there like Previous Same Month Year Qty And Previous Same Month Year Value

     and i have scheduled this report for a Auto Mail so user is getting confused with the columns.

     if i am making separate expression menace i have to add 50+ expressions.

      

Regards,

Ajith