topic Re: Sum divide by sum Total in QlikView

Sum divide by sum Total

ashmitp869 — Tue, 25 May 2021 02:58:41 GMT

Hi there ,

Please kindly suggest with the set analysis expression :

Expression :

%Death by /Death in whole

Dimension : =[$(vDisplayedBy)]

Expression :

Sum({$<Mode_Desc={'Death'}>}Measure)/Sum({$<[Mode_Desc]={'Death'},[$(vDisplayedBy)]=>} Measure)

Sum(Measure)/Sum(Total <[$(vDisplayedBy)]>Measure) , I need to put the condition Mode_Desc={'Death'}

But my expression not working

Variable details:

set vDisplayedBy='Facility';

abhijith28 — Tue, 25 May 2021 07:42:49 GMT

Can you attach the sample app.

MayilVahanan — Tue, 25 May 2021 08:42:48 GMT

Try like below

Sum({<Mode_Desc={'Death'}>}Measure)/Sum(Total <[$(vDisplayedBy)]> {<Mode_Desc={'Death'}>}Measure)