topic Re: Sum elements from 2 different fields depending on a condition in QlikView

Sum elements from 2 different fields depending on a condition

Thu, 02 Mar 2017 00:05:01 GMT

Hi,

I have this flat table in my app in Qliksense:

What I want is to have a single expression that can sum the larger of Cost or Price for all Products (essentially summing all the bold cell).

I was thinking of creating like a dummy table using aggr that produce something like this:

and just simply sum the Max(Price,Cost) field. But I haven't really come up with anything yet.

Please let me know if this is the right way or there is a better approach. Thanks!

aarkay29 — Thu, 02 Mar 2017 01:53:08 GMT

Try This

RangeMax(Price,Cost)

Thu, 02 Mar 2017 18:57:47 GMT

Thanks! I managed to use that in my data load editor as:

LOAD

...

RangeMax(Price,Cost) as MaxPC

...

And I just need to sum the MaxPC field as usual within the app. It works perfectly this way.