topic Re: Business case in QlikView

Business case

soniasweety — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Business case

BalaBhaskar_Qlik — Thu, 26 Jul 2018 11:16:16 GMT

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

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

Re: Business case

BalaBhaskar_Qlik — Thu, 26 Jul 2018 11:19:16 GMT

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

Re: Business case

soniasweety — Thu, 26 Jul 2018 11:33:06 GMT

thanks bala,

what is the Total will do here?

could you please explain me with simple way?

Re: Business case

BalaBhaskar_Qlik — Thu, 26 Jul 2018 11:39:35 GMT

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.

Re: Business case

hybrid_man — Thu, 26 Jul 2018 11:43:47 GMT

Hi, please read help for SUM function in Qlik:

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