topic Re: How to use a variable in set analysis. Variable contains a list of values in QlikView

How to use a variable in set analysis. Variable contains a list of values

paul_ripley — Sat, 16 Nov 2024 03:41:53 GMT

Hello

I have set up a variable vInvTrusts that contains a list of values - see below

=match(portfolio ,'02502028','088000313','012700003','088300009','02505011','EX2000','IC2000')

I then want to use this variable in set analysis so I can exclude these values from the dataset.

I have tried the below but this doest exclude anything - what am I doing wrong

sum({$ <period = {">=$(vStartPeriod_CY)<=$(vEndPeriod_CY)"} , pl = {F01}, DataSource = {Agresso}, entity = {0005,0010,0011,0177,0348,0502,0002,0413,0522},portfolio -= {$(vInvTrusts)} >} IS_Investment_GBP )*-1

Many thanks Paul

Re: How to use a variable in set analysis. Variable contains a list of values

marcus_sommer — Thu, 02 May 2019 12:09:58 GMT

If your variable contained:

'02502028','088000313','012700003','088300009','02505011','EX2000','IC2000'

it should work.

- Marcus

Re: How to use a variable in set analysis. Variable contains a list of values

paul_ripley — Thu, 02 May 2019 12:16:18 GMT

Hi Marcus

The variable vInvTrust I set up as below

So you think it should work?

=match(portfolio ,'02502028','088000313','012700003','088300009','02505011','EX2000','IC2000')

Re: How to use a variable in set analysis. Variable contains a list of values

marcus_sommer — Thu, 02 May 2019 12:21:26 GMT

No, not with such function, at least not with this kind of syntax - it was meant just as a list of strings.

- Marcus

Re: How to use a variable in set analysis. Variable contains a list of values

paul_ripley — Thu, 02 May 2019 12:28:42 GMT

Many thanks for your help