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
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
mahitham
Creator II
Creator II

Percentage calculation Help

Hi Experts,

Can any one please help me on below requirement.

I have Two KPIs Current Month Amount and Previous Month Amount

[CM Amount] =Count({<[Month Year]={$(=Max([Month Year]))}>}Sales)          Result : 32.68

[PM Amount] =Count({<[Month Year]={$(=Max([Month Year])-1)}>}Sales)      Result : 27.31


Please help me to write the expression for how much Amount Percentage increased in Current Month compared to Previous Month.

Thanks in advance

1 Solution

Accepted Solutions
raceberos
Partner
Partner

you can try this

(

Count({<[Month Year]={$(=Max([Month Year]))}>}Sales)  

/

Count({<[Month Year]={$(=Max([Month Year])-1)}>}Sales)

)

-1

the increase would be 20%

so you can get the percentage increase

View solution in original post

2 Replies
tush
Creator II
Creator II

Hi,

     Please refer below link:-

Calculating Percentage Change

raceberos
Partner
Partner

you can try this

(

Count({<[Month Year]={$(=Max([Month Year]))}>}Sales)  

/

Count({<[Month Year]={$(=Max([Month Year])-1)}>}Sales)

)

-1

the increase would be 20%

so you can get the percentage increase