Discussion Board for collaboration related to QlikView App Development.
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..
In the straight table chart use
Dimension:- Year &'-' & Month
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.
View solution in original post
In the load script you can achieve this by the below code
LOAD * Inline
Month, Revenue, OutPut
Jan, 40, -
Feb, 60, 50
Mar, 75, 25
Apr, 100, 33.33333333
May, 125, 25
June, 150, 20
Revenue as Rev,
( Revenue - Previous(Revenue) ) * 100 / Previous(Revenue) as PrevRevenue
And in chart take Dimension and Expression
Note:- In the sort properties select the Year &'-' & Month and only select Load Order.