Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

philmywallet
Not applicable

Monthly percentage change in a chart?

Can anyone tell me how I can show the change from the start month in a chart based on the WTE data only.  I can do this easily in excel.

My MS Excel example is below :

WTE                            Percent_Change (Calculated field)
1,200.59
1,204.740.35%
1,207.960.61%
1,221.051.70%
1,244.073.62%
1,248.283.97%
1,252.554.33%
1,266.435.48%
1,266.715.51%
1,268.425.65%
1,281.086.70%
1,280.686.67%
1,272.565.99%
1,263.485.24%
1,249.604.08%
1,250.704.17%
1,240.243.30%
1,232.572.66%

I want to show the percentage and the current WTE(Example below) :

pic_Graph.jpg

Thanks

Phil

Tags (2)
1 Solution

Accepted Solutions
jsn
Not applicable

Re: Monthly percentage change in a chart?

Heya Phil,

Here are two examples in one app:

1. Using a calculated field in the script to create the WTE change % as a field in your data model.

or

2. Calculate the WTE change % on the fly in the chart using the Above() interrecord function.

3 Replies
arasantorule
Not applicable

Re: Monthly percentage change in a chart?

Hi Phil,

Yes. It can be achieved by using the below expression.

=(WTE-top(only(WTE)))/top( only(WTE))*100

Thanks.

jsn
Not applicable

Re: Monthly percentage change in a chart?

Heya Phil,

Here are two examples in one app:

1. Using a calculated field in the script to create the WTE change % as a field in your data model.

or

2. Calculate the WTE change % on the fly in the chart using the Above() interrecord function.

veidlburkhard
Not applicable

Re: Monthly percentage change in a chart?

Hi Phil,

see below an easy to create chart which comes close to your needs:

WTEs.jpg

You have to use a Combo Chart with month as dimension and expression Sum(WTE) as bar chart. Expression Sum(WTE) / 1200.59 - 1 as line chart. Second axis is for %.

Hope this helps.

Burkhard