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: 
Not applicable

Calculating Percentage Change

Hi Experts,

I have 6 month end data for sales. For 6 months i have defined 6 variables.I am trying to calculate month on month sales variance in the expression of a chart.

screen shot.JPG

I want to calculate and show the percentage change in the expression as shown above.

Please note that my chart will 2 columns:

1. The selected month

2. Variance between the selected month and its previous month, in percentage.

Hopefully I am able to make you understand what exactly I am looking for.

Thanks in advance

Paul..

8 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Can you please tell me how your calculating selected month and previous month sales?

Celambarasan

Not applicable
Author

Selected months are set as variables. there are 6 variables for 6 months.

Jan 12 - Var1

Dec11 - Var2

Nov11 - Var3

Oct11 - Var4

Sept11 - Var5

Aug11 - Var6

I have defined variables for the months to make the chart dynamic.

Previous month sales are not calculated. data for the sales are in the data file.

Not applicable
Author

Hi,

see the attached example for help.

Good Luck!

Rainer

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

     Check this example.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable
Author

Hi Rainer,

Thanks for your input.

This is not exactly I am looking for.

What I want is :

My chart will only show two columns

1. The latest month sales data ( Jan 12 as shown above)

2. Percentage change of Jan 12 with Dec 11 ( But Dec 11 data will not appear in the chart)

And I want to make this dynamic ( To make it dynamic I have defined 6 variables for 6 months)

Jan 12 - Var1

Dec11 - Var2

Nov11 - Var3

Oct11 - Var4

Sept11 - Var5

Aug11 - Var6

Var1 will show the latest month end date within the date range

Var2 will show month prior to Var1

..... and so forth..

jvitantonio
Luminary Alumni
Luminary Alumni

Are you sure you want to do it with variables like this? This is not dynamic... Can we offer you another solution?

Not applicable
Author

Hi qlikuser,

Please , If you can, It will of great help !

jvitantonio
Luminary Alumni
Luminary Alumni

Here it is