Solved: How can I add a percentage of sales growth - Pivot... - Qlik Community

Anonymous · ‎2017-12-07

Hi everyone,

I want to add a percentage of sales growth from year 1 to year 2 for each category.

It should be something like this:

The formula

% increase = ((Sales year 2 - Sales year 1) ÷ Sales year 1) X 100

luismadriz · ‎2017-12-07

Hi Abbas,

Turn On Totals for Year and change the sales measure to this:

If(Dimensionality()=1,Sum(Sales),Num((Sum({<Year={2}>}Sales)-Sum({<Year={1}>}Sales))/Sum({<Year={1}>}Sales),'0%'))

I hope this helps,

Cheers,

Luis

luismadriz · ‎2017-12-07

Hi Abbas,

Turn On Totals for Year and change the sales measure to this:

If(Dimensionality()=1,Sum(Sales),Num((Sum({<Year={2}>}Sales)-Sum({<Year={1}>}Sales))/Sum({<Year={1}>}Sales),'0%'))

I hope this helps,

Cheers,

Luis

Anonymous · ‎2017-12-07

Hi Luis,

Almost there. See what I got

luismadriz · ‎2017-12-07

Good, you now just need to change Sum(Sales) to Num(Sum(Sales),format)

And maybe change the label for Totals to %Growth

Anything else?

Anonymous · ‎2017-12-07

Thanks a lot

luismadriz · ‎2017-12-07

You're welcome, you did a good job explaining and documenting the question,

Cheers,

Luis

Anonymous · ‎2017-12-07

Thanks again

How can I add a percentage of sales growth - Pivot table.