Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist III
Specialist III

Business case

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

Tags (2)
1 Solution

Accepted Solutions
Highlighted

Re: Business case

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

or

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

View solution in original post

5 Replies
Highlighted

Re: Business case

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

or

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

View solution in original post

Highlighted

Re: Business case

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

Highlighted
Specialist III
Specialist III

Re: Business case

thanks bala,

what is the  Total will do here?

could you please explain me with simple way?

Highlighted

Re: Business case

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.

Highlighted
Contributor II
Contributor II

Re: Business case