Set analysis/Expression/Calculation

[nicouek]

Hi, all
I have a bit of a problem I need assistance with, your help will be much appreciated.

I have FIELDS:
[emp_ID]-->123456
[active_emp_flag]--> 'Y' OR 'N'
[year]--> 2022 - 2013

LOGIC: If Year = 2022, Count distinct [emp_ID] where [active_emp_flag] = 'Y'

OTHERWISE

Just Count distinct [emp_ID] for the other years.

if you need further information please ask

Thank you

[luizcdepaula]

Hi,

Try the below:

If(Year='2022',Count(distinct {<[active_emp_flag] ={'Y'}>}[emp_ID]),Count( distinct [emp_ID]))

I hope it works.

Cheers,

Luiz

[nicouek · Accepted solution]

Hi Luizcdepaula,

Thank you, your answer was very helpful, though the formula does fantastic in my line chart, it's crashing both my Pivot and Straight table visualizations (those are the two visualizations I have tested

; nonetheless I appreciate your time and input.

Sincerely...

[BrunPierre]

@nicouek might interest you to check this ; Qlik Sense: "Calculation timed out" while loading a chart into an application 

[nicouek]

Hi, Peter

Just PING the Admin in my environment, for a meeting to look into the "Calculation timed out"; I will review the resource you sent for personal edification, Thank you very much!