Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
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
Author

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