Display expression total based on values

[newqlik2017]

 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 · Accepted solution]

May be this

Sum(DISTINCT LOCATION_PREMIUM) * Count(DISTINCT LOCATION)

[mayuringale25]

For Case 1

For Case 2:

[newqlik2017]

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