topic Re: Variable in Set Analysis in QlikView

Variable in Set Analysis

Wed, 25 Nov 2020 16:16:04 GMT

Hi all

I am struggling to get a variable in set analysis to return the correct amount

count({<[*Lineout Type]={'$(vLineout_FCV_Win)'}>} [*Lineout Type])

where

vLineout_FCV_Win = FirstSortedValue(DISTINCT [*Lineout Type],-aggr(count({<[*Result]={'Win'}>}[*Lineout Type])+rank([*Lineout Type],[*Lineout Type])/10,[*Lineout Type]))

Thanks

Re: Variable in Set Analysis

Vegar — Tue, 06 Dec 2016 07:41:41 GMT

I usually put my expression in a straight table with no column header. The expression will become the header and you will Gorky get an indication on what's wrong.

Have you tried the following expression?

count({<[*Lineout Type]={"$(=vLineout_FCV_Win)"}>} [*Lineout Type])

Re: Variable in Set Analysis

marcus_sommer — Tue, 06 Dec 2016 07:44:30 GMT

Starts the variable vLineout_FCV_Win with an equal sign? Does this variable return the expected value?

Quite helpful to see how an expression is evaluated is to use a table-chart for it and don't using a name for them and then viewing the evaluation within the expression-label.

- Marcus

Re: Variable in Set Analysis

Tue, 06 Dec 2016 07:58:38 GMT

Hi there,

Yes, I have tried the expression and get the return of zero

Re: Variable in Set Analysis

Tue, 06 Dec 2016 08:00:15 GMT

No, I get the error ''Error in set modifier ad hoc element list: ',' or ')' expected''

Re: Variable in Set Analysis

marcus_sommer — Tue, 06 Dec 2016 08:09:44 GMT

For the variable itself or for the expression with variable? Especially in such cases is it useful to look within the label how the expression will be evaluated and I would further split the approach into several steps by splitting the count- and aggr- and rank-functions to ensure they return the right results.

- Marcus

Re: Variable in Set Analysis

Tue, 06 Dec 2016 08:21:45 GMT

For the expression with variable.

The variable itself is returning the correct amount

Re: Variable in Set Analysis

marcus_sommer — Tue, 06 Dec 2016 08:59:28 GMT

Starts the variable vLineout_FCV_Win with an equal sign?

- Marcus

Re: Variable in Set Analysis

muthukumar77 — Tue, 06 Dec 2016 16:02:22 GMT

Hi,

1. Create variable,

vLineout_FCV_Win

[*Lineout Type]=FirstSortedValue(DISTINCT [*Lineout Type],-aggr(count({<[*Result]={'Win'}>}[*Lineout Type])+rank([*Lineout Type],[*Lineout Type])/10,[*Lineout Type]))

2. count({<$(vLineout_FCV_Win)>} [*Lineout Type])

Re: Variable in Set Analysis

krishnacbe — Tue, 06 Dec 2016 16:30:47 GMT

Hi,

If your variable declaration is in Script, try with LET Statement instead of SET. Sometimes this will solve the issue.

Re: Variable in Set Analysis

Fri, 06 Jan 2017 10:50:59 GMT

Hi Marcus

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

Re: Variable in Set Analysis

marcus_sommer — Fri, 06 Jan 2017 11:26:54 GMT

I think you need to use: '$(vSTATS_Top_LineoutCombo_Win)' as far as your variable-expression will be caluclated within the variable.

- Marcus

Re: Variable in Set Analysis

nagarjuna_kotha — Fri, 06 Jan 2017 11:33:13 GMT

Please provide below info :

1.if u take that variable in text box , what is ur output in it ?

2.What is Lineout Type consist.

-Nagarjun

Re: Variable in Set Analysis

Sat, 07 Jan 2017 06:14:19 GMT

The output is ''5 Man / Middle''

Lineout Type consists of text strings (5 Man, 4 Man, Full)