Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Percentage table

Hi

This table shows per Prodexchange a monthly Quantity, say September.

How can I get % change compared to previous month (August) in the column next to Sum([#Quantity])??

Thanks

perc.JPG

Tags (3)
4 Replies

Re: Percentage table

Would you be able to share a sample to test this out?

xufei123
Valued Contributor

Re: Percentage table

Let's say the month field is "RollMonth" and you have selected "Sep 2016".

You have another field called "Date".

Here is the measure that you need to use to have the quantity for previous month.

sum({<RollMonth=, Date={">=$(=monthstart(max(Date),-1))<=$(=monthend(max(Date),-1))"}>} [#Quantity])

You should be able to figure out the change % using this.

Not applicable

Re: Percentage table

hey fei, thats helpful. I now have this, according to your formula, for the second #quantity column:

sum({<Month=, Date={">=$(=monthstart(max(Date),-1))<=$(=monthend(max(Date),-1))"}>} [#Quantity])

How would I then make the next column the percentage % cahnge between 1st and 2nd column?

perc.JPG

Not applicable

Re: Percentage table

got it thanks!

Community Browser