topic Percentage calculation Help in QlikView

Percentage calculation Help

pawwy1415 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

Can any one please help me on below issue.

Left hand Low% is calculated as like below

=(Count({<[Year]={$(=Max([Year])-1)},

[Rating]={'Low'}>}distinct [ID]))/

(Count({<[Year]={$(=Max([Year])-1)},[Rating]={'Low'}>}distinct [ID])+Count({<[Year]={$(=Max([Year])-1)},[Rating]={'High'}>}distinct [ID])+

Count({<[Year]={$(=Max([Year])-1)},[Rating]={'Medium'}>}distinct [ID]))

Right hand Low% is calculated as like below

=(Count({<[Year]={$(=Max([Year])-1)}>}distinct [ID])/(Count({<[Year]={$(=Max([Year])-1)}>}total distinct [ID])

but both values are not matching

Please help me on this.

Thanks in advance

Re: Percentage calculation Help

olivierrobin — Tue, 05 Jun 2018 07:36:04 GMT

hello

the expression are not the same

in the 1st, you take only 'low' values as numerator and in the 2nd one, you take all values

try to add the same set analysis in both

Re: Percentage calculation Help

sasiparupudi1 — Tue, 05 Jun 2018 08:30:21 GMT

May be try

Avg(Aggr((Count({<[Year]={$(=Max([Year])-1)}>}distinct [ID])/(Count({<[Year]={$(=Max([Year])-1)}>}total distinct [ID]),

MonthYear)

)

Re: Percentage calculation Help

pawwy1415 — Tue, 05 Jun 2018 09:00:23 GMT

The below expression is working fine

=(Count({<[Year]={$(=Max([Year])-1)},

[Rating]={'Low'}>}distinct [ID]))/

(Count({<[Year]={$(=Max([Year])-1)},[Rating]={'Low'}>}total distinct [ID])+Count({<[Year]={$(=Max([Year])-1)},[Rating]={'High'}>}total distinct [ID])+

Count({<[Year]={$(=Max([Year])-1)},[Rating]={'Medium'}>}total distinct [ID]))