Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Sum([Service Margin]) / Sum(ServiceRK)
or
Sum(TOTAL [Service Margin]) / Sum(TOTAL ServiceRK)
Sum([Service Margin]) / Sum(ServiceRK)
or
Sum(TOTAL [Service Margin]) / Sum(TOTAL ServiceRK)
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
thanks bala,
what is the Total will do here?
could you please explain me with simple way?
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.
Hi, please read help for SUM function in Qlik: