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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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)