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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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

Labels (1)
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)