Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
pradeepm
Contributor II
Contributor II

Incremental Percentage Monthwise

Hi Everyone,

I have a requirement to show the monthly incremental percentage of Revenue. Here i have created a concatenated field with Year &'-' & Month as a dimension. Please tell me how can i show the monthly incremental percentage as shown in excel & image..

1 Solution

Accepted Solutions
its_anandrjs

In the straight table chart use

Dimension:- Year &'-' & Month

Expression1:- sum(Revenue)

Expression2:- (sum(Revenue) - above( sum(Revenue))  ) * 100 / above( sum(Revenue))

Note:- in the sort properties select the Year &'-' & Month and only select Load Order this will done in the front end level only you can achieve this in the script level also.

Regards,

Anand

View solution in original post

3 Replies
its_anandrjs

In the straight table chart use

Dimension:- Year &'-' & Month

Expression1:- sum(Revenue)

Expression2:- (sum(Revenue) - above( sum(Revenue))  ) * 100 / above( sum(Revenue))

Note:- in the sort properties select the Year &'-' & Month and only select Load Order this will done in the front end level only you can achieve this in the script level also.

Regards,

Anand

View solution in original post

maxgro
MVP
MVP

see attachment

1.png

its_anandrjs

In the load script you can achieve this by the below code

Data:

LOAD * Inline

[

Month, Revenue, OutPut

Jan, 40, -

Feb, 60, 50

Mar, 75, 25

Apr, 100, 33.33333333

May, 125, 25

June, 150, 20

];

NewTable:

LOAD

Month,

Revenue as Rev,

( Revenue - Previous(Revenue) ) * 100 / Previous(Revenue) as PrevRevenue

Resident Data;

And in chart take Dimension and Expression

Dimension:- Year &'-' & Month

Expression1:- sum(Revenue)

Expression2:- sum(PrevRevenue)

Chart.png

Note:- In the sort properties select the Year &'-' & Month and only select Load Order.

Regards,

Anand