topic Summing SET ANALYSIS with DISTINCT Variable in QlikView

Hi,

I am working on writing an expression that pulls in the Total $ for the current year, based on episode number. However, since episode number is repetitive on multiple claim lines, I would want the expression to be distinct on the episode number.

CY TOTAL PAID $:

=SUM({$<[Report Year] = {'Current Year'}>} TOTAL_ALLOWED)

CY TOTAL EPISODES:

=COUNT({$<[Report Year] = {'Current Year'}>} DISTINCTepisode_num)

I have the expressions laid out, but realized the CY TOTAL PAID value in the first expression is not distinct based on episode number, so the $ is tripling its value. How would I make the SUM of the SET ANALYSIS in CY TOTAL PAID to be SUMMING based on DISTINCT episode number only?

Please advise.

Thank you,
Clem☺

topic Summing SET ANALYSIS with DISTINCT Variable in QlikView

Summing SET ANALYSIS with DISTINCT Variable

Re: Summing SET ANALYSIS with DISTINCT Variable

Re: Summing SET ANALYSIS with DISTINCT Variable

Re: Summing SET ANALYSIS with DISTINCT Variable