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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
microwin88x
Creator III
Creator III

Count in Set Analysis with a Specific Value

Hello!

I have the following expression:

= COUNT ({$<ID_TIE_DATE#={">=$(='$(vDateFrom)')<=$(='$(vDateTo)')"}>} Q_VALUES)

Where the field Q_VALUES could have values like: 0 or 6.

What I want is to count only those values who have a 6.

Do you know how could I do that?

Thank you!!!

1 Solution

Accepted Solutions
alexandros17
Partner - Champion III
Partner - Champion III

= COUNT ({$<ID_TIE_DATE#={">=$(='$(vDateFrom)')<=$(='$(vDateTo)')"}, Q_VALUES={6}>} Q_VALUES)

View solution in original post

1 Reply
alexandros17
Partner - Champion III
Partner - Champion III

= COUNT ({$<ID_TIE_DATE#={">=$(='$(vDateFrom)')<=$(='$(vDateTo)')"}, Q_VALUES={6}>} Q_VALUES)