Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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 - Contributor III
Partner - Contributor III

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 - Contributor III
Partner - Contributor III

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