Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
waqasshah
Creator
Creator

Dimesnion % Calculation

Dear Experts,

I need your help. Actually I  need to calculate the percentage between the dimension columns. Please review the attached picture. The top 2 percentage calculations marked with red sign are my desired results. Can anyone please tell me how to do these calculation in chart or on a text box ?

Thanks in advance

 

Regards

Waqas Shah

 

Labels (1)
11 Replies
sunny_talwar

Check attached...

Script changes

ActivitySales:
LOAD *,
	 SubField(ActivityFinancialYear, '/', 2) as Year;
LOAD * INLINE [
    SalesItem, ActivityPrice, ActivityDate, ActivityMonth, ActivityFinancialYear
    1, 100, 01-01-2015, January, 2015/2016
    2, 200, 20-01-2015, January, 2015/2016
    1, 150, 15-02-2015, February, 2015/2016
    2, 210, 22-02-2015, February, 2015/2016
    1, 250, 01-03-2015, March, 2015/2016
    2, 270, 10-03-2015, March, 2015/2016
    2, 300, 19-04-2016, April, 2016/2017
    2, 600, 13-04-2016, April, 2016/2017
    2, 970, 25-05-2016, May, 2016/2017
    2, 120, 28-05-2016, May, 2016/2017
    2, 330, 03-06-2016, June, 2016/2017
    2, 650, 06-06-2016, June, 2016/2017
    2, 170, 07-07-2017, July, 2017/2018
    2, 960, 09-07-2017, July, 2017/2018
    2, 150, 10-08-2017, August, 2017/2018
    2, 235, 11-08-2017, August, 2017/2018
    2, 344, 14-09-2017, September, 2017/2018
    2, 496, 15-09-2017, September, 2017/2018
    2, 483, 06-10-2018, October, 2018/2019
    2, 798, 27-10-2018, October, 2018/2019
    2, 101, 23-11-2018, November, 2018/2019
    2, 502, 30-11-2018, November, 2018/2019
    2, 659, 19-12-2018, December, 2018/2019
    2, 710, 03-12-2018, December, 2018/2019
];

Expression

=Num(Sum({<Year = {"$(=Max(Year))"}>} ActivityPrice)/Sum({<Year = {"$(=Max(Year)-1)"}>} ActivityPrice)-1, '##.#%')

View solution in original post

waqasshah
Creator
Creator
Author

Many Thanks you are a star..HeartSmiley Happy