Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

limorpe1977
New Contributor

Qliksense - add column to pivot table

Hi,

I have a pivot table in qliksense and need to add a column of % growth between 2017 and 2018.

if i add it as a measure i get the amount on each Quarter  instead of only one time in the end.

This i what i need:

     

2017SUM 2018SUM Growth
Q2Q3Q4 Q1Q2Q3Q4
50.00100.00200.00150.0080.0054.0089.0091.00314.00 12%

Thanks for any help

Cheers,

3 Replies
praveenkumar_ma
Contributor

Re: Qliksense - add column to pivot table

Hi Limor,

I had a situation like this before,

we tried to add the difference ,

in your case it is growth...

i think i pivot we cannot add it as measure , which will reflects in to two years.

instead of Pivot table we managed with straight table as a seperate column at the end ..

might be helpful..

Thanks

PM

limorpe1977
New Contributor

Re: Qliksense - add column to pivot table

Hi,

Thanks Praveen,

but How did you had add the columns year and quarter in a straight table?

Regards,

praveenkumar_ma
Contributor

Re: Qliksense - add column to pivot table

Hi Limor,

i understand there will be redundent data,

well in Our case it is a master Detail sheet , we had added year and quarter as dimensions and measures asusual and growth percentage as measure .

might be helpful......

Thanks

PM.