Discussion board where members can get started with QlikView.
i want below into Qlik language like sample way to calculate the below logic can anyone help me?
Calculate Total Service Margin/Total ServiceRK ?
Sum([Service Margin]) / Sum(ServiceRK)
Sum(TOTAL [Service Margin]) / Sum(TOTAL ServiceRK)
View solution in original post
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
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: