Set Analysis parenthesis help

[egbert_jones]

I have the following set analysis statement  which counts the no of players for Florida where 'myscore' is less than the variable vScore.

=NUM(COUNT({<MyScore={"<$(vScore)"},State={'Florida'}>}DISTINCT Player_ID),'#,##0')

What I want to do instead is replace 'myscore' with a field called 'TuesdayScore' which is set to 1 ie TuesdayScore={1}

Thanks

[trdandamudi]

Can you give a try on the below expression:

NUM(COUNT({<TuesdayScore={1},State={'Florida'}>}DISTINCT Player_ID),'#,##0')

[egbert_jones]

This doesn't seem to take into consideration the 'vScore' variable

[trdandamudi]

I thought you want to replace MyScore with TuesdayScore. If you want to retain both then give a try with the below expression:

NUM(COUNT({<MyScore={"<$(vScore)"},TuesdayScore={1},State={'Florida'}>}DISTINCT Player_ID),'#,##0')

[Brett_Bleess]

Did the last reply get you what you needed?  If so, be sure to click the Accept as Solution button on that post to give them credit for the help.  If you are still struggling, provide an update with further information, but here are some links that may be somewhat helpful as well:

Help:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/...

Design Blog:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

There are quite a few other posts on Set Analysis in the Design Blog area too, so if the one above is not helpful, try searching on the others to see if they help.

Regards,
Brett