Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Calculating Percentage Change

Hi,

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

Celambarasan

Not applicable

Calculating Percentage Change

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

Re: Calculating Percentage Change

Hi,

see the attached example for help.

Good Luck!

Rainer

Re: Calculating Percentage Change

Hi,

     Check this example.

Regards,

Kaushik Solanki

Not applicable

Calculating Percentage Change

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
Valued Contributor III

Calculating Percentage Change

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

Not applicable

Calculating Percentage Change

Hi qlikuser,

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

jvitantonio
Valued Contributor III

Re: Calculating Percentage Change

Here it is

Community Browser