topic Re: Set Analysis parenthesis help in QlikView

Set Analysis parenthesis help

egbert_jones — Thu, 11 Jul 2019 11:20:01 GMT

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

Re: Set Analysis parenthesis help

trdandamudi — Thu, 11 Jul 2019 12:36:44 GMT

Can you give a try on the below expression:

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

Re: Set Analysis parenthesis help

egbert_jones — Thu, 11 Jul 2019 13:25:50 GMT

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

Re: Set Analysis parenthesis help

trdandamudi — Thu, 11 Jul 2019 13:29:53 GMT

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')

Re: Set Analysis parenthesis help

Brett_Bleess — Tue, 06 Aug 2019 13:43:41 GMT

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/SetAnalysis/set-analysis-expressions.htm

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