topic Re: Prob in Pivot Table !! in QlikView

Prob in Pivot Table !!

nikhilgarg — Tue, 16 Dec 2014 06:42:45 GMT

HEy,

I have created a Pivot table.

In that table , i have done partial sum.

I want the label for that total to be Month_Year &'Total : ' , where Month_Year is my dimension.

But it is showing only Total: . Month_Year is not appended to it.

IS there any way to append the dimension before Total like:

Jan2014 Total , Feb2014 Total etc.

Thanks

tyagishaila — Tue, 16 Dec 2014 07:33:24 GMT

Hi Nikhil,

You have to use variable for it, in the place of Label for Total (Below Show Partial Sums).

like:

=Year(vDate)

where vDate is you variable for it

arulsettu — Tue, 16 Dec 2014 07:40:37 GMT

in label try like this

=Month_Year &'Total : '

nikhilgarg — Tue, 16 Dec 2014 09:11:34 GMT

I have tried like this only but it shows only :

Total: