Discussion Board for collaboration related to QlikView App Development.
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!
Go to Solution.
Thanks! I managed to use that in my data load editor as:
RangeMax(Price,Cost) as MaxPC
And I just need to sum the MaxPC field as usual within the app. It works perfectly this way.