Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

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

1 Solution

Accepted Solutions
balabhaskarqlik

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

or

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

View solution in original post

5 Replies
balabhaskarqlik

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

or

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

View solution in original post

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
Master
Master

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
Contributor II
Contributor II