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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
eddywong71
Creator
Creator

Decile Analysis compare with last year

Hi All,

I am using this set expression for current year and last year

=Aggr(
Ceil(Rank(Sum($Profit),4,1) / count($DISTINCT TOTAL Customer), 0.1) * 10
, Customer) 

Last year

=Aggr(
Ceil(Rank(Sum($Profit_Last_Year),4,1) / count($DISTINCT TOTAL Customer), 0.1) * 10
, Customer)

 Table as below

decile1.PNG

However, I want create a two column on Past 12 Month. Upgrade and downgrade for example select 20% from Past 12 Month. Upgrade =  138+.....+24 and Downgrade = 119. How can I create a set expression for Upgrade and downgrade.

decil2.PNG

Can anyone help ?

 

Labels (6)
0 Replies