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

Announcements
Mastering Change Data Capture: Read Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Broly
Contributor III
Contributor III

Convert condition to set analysis

Hi guys,

 

can someone help me with conversion from

if(Match([Month/Year],TermDate) and Flag='Termination', count(distinct [Empl ID])) to Set analysis format?

 

Thank you

Labels (1)
1 Solution

Accepted Solutions
rubenmarin

Hi, Maybe? count(distinct {<[Month/Year]={"TermDate"},Flag={'Termination'}>} [Empl ID])

Maybe needs some fix to use TermDate in the same format as [Month/Year].

View solution in original post

2 Replies
rubenmarin

Hi, Maybe? count(distinct {<[Month/Year]={"TermDate"},Flag={'Termination'}>} [Empl ID])

Maybe needs some fix to use TermDate in the same format as [Month/Year].

Broly
Contributor III
Contributor III
Author

Not exactly what I needed but thank you 🙂