Discussion board where members can get started with Qlik Sense.
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:
Thanks for any help
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..
but How did you had add the columns year and quarter in a straight table?
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......