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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expression conversion

Hi All,


As part of a revamp of some existing code (which is helping with my learning) I am trying to convert

count({1<IncidentType={'*Accident*'},ListTitle={'*Employee*'}>}IncidentPersonID)

to

count({<DateRaisedIMS={">=$(=MonthStart(Today(),-11))<=(=MonthEnd(Today())"},IncidentType={'*Accident*'},ListTitle={'*Employee*'}>}IncidentPersonID)


However in the first expression there is a 1< which I have no idea of the meaning.

I have googled and search but I can not find anything and my syntax knowledge is such that I don't know how to fit it into the converted expression (it is missing above)

As always any guidance or help is much appreciated

Toby

2 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

The 1 means ignore all user selections. It goes in the same place

count({1<....

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

Thanks Jonathan,

how would I add that into the new expression (I am trying to replicate existing figures)