topic Re: Decile Analysis compare with last year in App Development

Decile Analysis compare with last year

eddywong71 — Wed, 08 Feb 2023 08:11:41 GMT

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

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.

Can anyone help ?

Re: Decile Analysis compare with last year

vinieme12 — Wed, 08 Feb 2023 08:13:16 GMT

Try Fractile()

https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/ChartFunctions/StatisticalAggregationFunctionsinCharts/fractile.htm

Re: Decile Analysis compare with last year

eddywong71 — Wed, 08 Feb 2023 08:42:58 GMT

Hi Vinieme12, would you provide more detail on how to write a set expression by using Fractile() can auto calculate Upgrade and downgrade in auto when select from Past 12 Month .

Re: Decile Analysis compare with last year

eddywong71 — Wed, 08 Feb 2023 12:59:17 GMT

Can anyone help 🙌

Re: Decile Analysis compare with last year

vinieme12 — Thu, 09 Feb 2023 02:13:33 GMT

can you post a sample app?