topic Re: Set Analysis Error in QlikView

Set Analysis Error

Wed, 25 Nov 2020 16:16:04 GMT

Hi all

I am still struggling with adding the variable to a set analysis expression

count({$<STATS_LineoutType_Number_Combo={'vSTATS_Top_LineoutCombo_Win'}>} STATS_LineoutType_Number_Combo)

where vSTATS_Top_LineoutCombo_Win = firstsortedvalue( DISTINCT STATS_LineoutType_Number_Combo, -Aggr(count({<STATS_LineoutType_Number_Combo-={' / '},[STATS Group Movement Result]={'Effective'}>}STATS_LineoutType_Number_Combo),STATS_LineoutType_Number_Combo))

I get the error;

Error in set modifier ad hoc element list:

',' or ')' expected

Regards

Re: Set Analysis Error

annafuksa1 — Fri, 06 Jan 2017 11:17:10 GMT

Try

count({$<STATS_LineoutType_Number_Combo={$(vSTATS_Top_LineoutCombo_Win)}>} STATS_LineoutType_Number_Combo)

and do not use DISTINCT in firstsortedvalue function

Re: Set Analysis Error

sunny_talwar — Fri, 06 Jan 2017 11:19:39 GMT

Have you tried using this expression in a text box object?

firstsortedvalue( DISTINCT STATS_LineoutType_Number_Combo, -Aggr(count({<STATS_LineoutType_Number_Combo-={' / '},[STATS Group Movement Result]={'Effective'}>}STATS_LineoutType_Number_Combo),STATS_LineoutType_Number_Combo))

Does it give you a single value? This is the same value which will be used in your set analysis and will stay the same across all dimensions? If that is all fine, then try this:

Count({$<STATS_LineoutType_Number_Combo={'$(=vSTATS_Top_LineoutCombo_Win)'}>} STATS_LineoutType_Number_Combo)

Re: Set Analysis Error

Fri, 06 Jan 2017 11:22:20 GMT

Thanks, but I still get the same error

Re: Set Analysis Error

annafuksa1 — Fri, 06 Jan 2017 11:32:23 GMT

the second problem is firstsortedvalue( DISTINCT STATS_LineoutType_Number_Combo, -Aggr(count({<STATS_LineoutType_Number_Combo-={' / '},[STATS Group Movement Result]={'Effective'}>}STATS_LineoutType_Number_Combo),STATS_LineoutType_Number_Combo))

you try to do operation on one to many value

I have not idea what should be the result but Aggr function should be to full expression not the part, or erase Aggr function.