Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

monthStart lesser than dimension date in set analysis


I want to show a count of number of errors detected before the start date of the current month in dimension.

This test works fine:


Count({<ERROR_DETECTION_DATE_QVD = {"$(='<='&'2021-05-01')"}>}ID_DQ_FACTS_QVD)


But this other code is not taking into account the condition of the monthStart, and it is returning all errors, not only the ones before monthStart:




EXEC_DATE_SQL_QVD is the current dimension date.

What am I doing wrong?

Thank you.

0 Replies