Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Set Analysis with a count condition

I need a set analysis to calculate an expression which should satisfy a count condition and it should look something like this:

=Sum({$<Count(case)={">$(=1)"}>} [POST DATE]- Max (SERV_DATE))

"case" is an autonumbered field created in the script and is a combination of three other fields. But the above set analysis expression that I created is not working. Would appreciate any help or ideas, thanks!

6 Replies
sunny_talwar

Against which dimension are you doing this Count(case) check against? POST DATE? SERV_DATE? What is the difference between the two dates here? and why use Max(SERV_DATE)?

vishsaggi
Champion III
Champion III

You cannot use Aggr function like Count() on left of the "="

May be like:

=Sum({$<case ={"=$(= Count(case) > 1)"}>} [POST DATE]- Max (SERV_DATE))

sunny_talwar

case is an autonumbered field.... so Count(case) against case will always = 1

vishsaggi
Champion III
Champion III

Oops got it. Thanks for that. Can you do a Sum(Aggr(Count(case), case)) ?

sunny_talwar

Don't think that will help.... what we need is to know what dimension are we doing this count on...

vishsaggi
Champion III
Champion III

Got it. Thanks Sunny...