Solved: Re: SetAnalysis - Qlik Community

Vittore8 · ‎2020-07-16

=count({<dateStart={'<=$(=date('01.07.2020')'}, dateEnd={'>=$(=date("01.07.2020")'}}>} CD_ID_DOG)

why it doesn't work???

Taoufiq_Zarra · ‎2020-07-16

Syntax Erros, check

=count({<dateStart={"<=$(=date('01.07.2020'))"},dateEnd={">=$(=date('01.07.2020'))"}>}  ID)

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

Taoufiq_Zarra · ‎2020-07-16

Syntax Erros, check

=count({<dateStart={"<=$(=date('01.07.2020'))"},dateEnd={">=$(=date('01.07.2020'))"}>}  ID)

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

agigliotti · ‎2020-07-16

Hi,

give a try with the below expression:

=count( {< dateStart = {"<=01.07.2020"}, dateEnd = {">=01.07.2020"} >} CD_ID_DOG )

what is the date format of dateStart and dateEnd fields?

The Power of shining a light on the dark side of your data.
Follow me on my LinkedIn | Know Gamma Informatica at gammainformatica.it

Vittore8 · ‎2020-07-16

date

SetAnalysis