Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis Question

Hi All, I could use a little help...

I'm trying to write a formula that will idenitify the number of "MRN's" (person identifier), for only those who have charges greater than Zero.... I have written the formula this way.... Would someone identify where i'm off?

 

=sum({$<TransactionType = {'Room Adj', 'Room Charge'}, AcctPerAndYear = {$(=max(AcctPerAndYear)), {

DISTINCT MRN}>} Units)

2 Replies
rbecher
MVP
MVP

Are you trying to mix count and sum here?

Astrato.io Head of R&D
Not applicable
Author

I believe i am...... I want a count of MRNS that have more than one unit.... hope that makes sense