Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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...
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
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...
@nicouek might interest you to check this ; Qlik Sense: "Calculation timed out" while loading a chart into an application
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!