topic Re: Dimension Values as a Pivot Expression Heading in QlikView

Dimension Values as a Pivot Expression Heading

ajithsachin — Tue, 03 Jun 2014 04:34:57 GMT

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

Re: Dimension Values as a Pivot Expression Heading

jagan — Tue, 03 Jun 2014 05:42:03 GMT

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.

Re: Dimension Values as a Pivot Expression Heading

its_anandrjs — Tue, 03 Jun 2014 05:56:52 GMT

With pivot table not possible.

Re: Dimension Values as a Pivot Expression Heading

ajithsachin — Tue, 03 Jun 2014 06:54:47 GMT

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