topic understand the formula in QlikView

understand the formula

Mon, 20 Apr 2015 12:17:08 GMT

help me understand this formula

sum({$<Month=,Year_Month=>} Coverage_Achievement_Qty) / sum({$<Month=,Year_Month=>} Coverage_Target_Qty)

Calendar:

LOAD * INLINE [

Year_Month

];

robert_mika — Mon, 20 Apr 2015 12:23:09 GMT

Is simple division of all values from Achievement_Qty field by all values from Target_Qty

You could write this as

sum( Coverage_Achievement_Qty) / sum(Coverage_Target_Qty)

jjordaan — Mon, 20 Apr 2015 12:59:11 GMT

Hi Mohammad,

This expression is summarizing the Coverage_Achievement_Qty but it is disregarding the selections for Month and Year_Month.

It is doing the same for Coverage_Target_Qty.

In the end the outcome for sumarizing Coverage_Achievement_Qty will be divided by Coverage_Target_Qty