topic Re: Display expression total based on values in QlikView

Display expression total based on values

newqlik2017 — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have a straight table in which I'm trying to capture the total value for case 1 and case 2 as see in the above example.

For Case 1, the location is the same (101) for two states - NY and DC. So the total for location premium should display 468.

For Case 2, the location is different (101 and 102) for NY and DC. So the total for location premium should display 936.

Any ideas on how this can be done in a single expression in Qlikview? Thanks!!!

sunny_talwar — Wed, 30 Sep 2020 14:53:33 GMT

May be this

Sum(DISTINCT LOCATION_PREMIUM) * Count(DISTINCT LOCATION)

mayuringale25 — Thu, 01 Oct 2020 06:58:21 GMT

For Case 1

For Case 2:

newqlik2017 — Thu, 01 Oct 2020 14:36:52 GMT

Thanks Sunny. I was able to tweak the formula and apply to my specific scenario.