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: 
Peony
Creator III
Creator III

Set analysis syntax with dates between shows error

Hi All!

I have an issue with set analysis syntax. I wat to take UID from period between max and min dates and count distinct UID values. And receive message that "error in set modifier ad hoch element list: ',' or ')' expected"
And I can't get where these symbols are expected.

Could you please help to understand what wrong with formula?

Count({<UID= {"<CALENDAR_YEARWEEK_STRING ={">=$(=v_PeriodStar) <=$(=v_PeriodEnd)"}>"}>} distinct UID) 

Labels (2)
1 Solution

Accepted Solutions
Kushal_Chawda

@Peony  only this should work

Count({<CALENDAR_YEARWEEK_STRING ={">=$(v_PeriodStar) <=$(v_PeriodEnd)"}>} distinct UID) 

View solution in original post

4 Replies
Anil_Babu_Samineni

Are you comparing UID with Calendar? try this? (PS, = can be removed if that is defined already in variable)

Count({<UID=P({<CALENDAR_YEARWEEK_STRING={">=$(=v_PeriodStar)<=$(=v_PeriodEnd)"}>} UID)>} distinct UID)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Kushal_Chawda

@Peony  only this should work

Count({<CALENDAR_YEARWEEK_STRING ={">=$(v_PeriodStar) <=$(v_PeriodEnd)"}>} distinct UID) 
Peony
Creator III
Creator III
Author

@Kushal_Chawda Indeed! Too many quotes I set. Thank you!

Peony
Creator III
Creator III
Author

@Anil_Babu_Samineni Thank you! Possible values set makes expression works