topic Re: Help with calculated field in App Development

Help with calculated field

Texas_Dave — Thu, 08 Aug 2019 14:03:51 GMT

I'm pulling a count of employees, and need to make a calculated field for a count of "New Hires". I am new to Qlik Sense but have worked in Tableau. The syntax is throwing me for a loop here.

I have it written in Tableau as:

COUNTD (IF DATEDIFF ('day',[Date Hired], DATEADD('day',-1,TODAY () ) ) <=45 THEN [Worker ID] END )

So far in Qlik Sense I have:

Count(IF Date('day',[Worker.HireDate], ' day',-1, Today () <=14 THEN [Worker.Wkr_ID] END)

Any help on the Qlik syntax would be greatly appreciated.

Re: Help with calculated field

mahaveerbiraj — Thu, 08 Aug 2019 15:04:09 GMT

Hi ,

if ( ([Worker.HireDate] - Today ())<45, [Worker ID] ) as newfield

and take count in chart using count(distinct newfield )

Note: take care of date format

Re: Help with calculated field

Texas_Dave — Fri, 09 Aug 2019 16:32:04 GMT

Thank you for the response. Is there a way to get it into one statement?