Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Alma1234
Contributor III
Contributor III

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
Partner - Creator
Partner - Creator

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

Alma1234
Contributor III
Contributor III
Author

Hi,

Thanks Praveen,

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

Regards,

praveenkumar_ma
Partner - Creator
Partner - Creator

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.