topic Re: Set analysis/Expression/Calculation in App Development

Set analysis/Expression/Calculation

nicouek — Wed, 10 Aug 2022 13:47:47 GMT

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

Re: Set analysis/Expression/Calculation

luizcdepaula — Wed, 10 Aug 2022 13:53:04 GMT

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

Re: Set analysis/Expression/Calculation

nicouek — Wed, 10 Aug 2022 16:25:17 GMT

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...

Re: Set analysis/Expression/Calculation

BrunPierre — Wed, 10 Aug 2022 17:17:21 GMT

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

Re: Set analysis/Expression/Calculation

nicouek — Wed, 10 Aug 2022 17:51:22 GMT

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!