Business case

[soniasweety]

Hi all,

i want  below into Qlik language  like  sample  way to calculate the below logic can anyone help me?

Calculate Total Service Margin/Total ServiceRK ?

Thanks

Sony

[balabhaskarqlik · Accepted solution]

Sum([Service Margin]) / Sum(ServiceRK)

or

Sum(TOTAL [Service Margin]) / Sum(TOTAL ServiceRK)

[balabhaskarqlik]

You can use like this also:

Sum(Sales)/Sum(TOTAL Sales) - returns the share within the selection

Sum(Sales)/Sum(TOTAL <Month> Sales) - returns the share within the selection for each Month

[soniasweety]

thanks bala,

what is the  Total will do here?

could you please explain me with simple way?

[balabhaskarqlik]

As i given an example in the above:

TOTAL qualifier means that the calculation will be made over all possible values given the current selections, but disregarding the chart dimension values.

[hybrid_man]

Hi, please read help for SUM function in Qlik:

https://help.qlik.com/en-US/sense/September2017/Subsystems/Hub/Content/ChartFunctions/BasicAggregati...