Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
newqlik2017
Creator II
Creator II

Display expression total based on values

newqlik2017_0-1601476786412.png

 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!!!

1 Solution

Accepted Solutions
sunny_talwar

May be this

Sum(DISTINCT LOCATION_PREMIUM) * Count(DISTINCT LOCATION)

View solution in original post

3 Replies
sunny_talwar

May be this

Sum(DISTINCT LOCATION_PREMIUM) * Count(DISTINCT LOCATION)

View solution in original post

mayuringale25
Partner
Partner

For Case 1

mayuringale25_0-1601535428564.png

For Case 2:

mayuringale25_1-1601535483860.png

 

 

 

Thanks and Regards
Mayur Ingale
newqlik2017
Creator II
Creator II
Author

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