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: 
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