Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
paul_ripley
Creator III
Creator III

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

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

Labels (2)
1 Solution

Accepted Solutions
marcus_sommer
MVP & Luminary
MVP & Luminary

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

- Marcus

View solution in original post

4 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

If your variable contained:

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

it should work.

- Marcus

paul_ripley
Creator III
Creator III
Author

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

marcus_sommer
MVP & Luminary
MVP & Luminary

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

- Marcus

View solution in original post

paul_ripley
Creator III
Creator III
Author

Many thanks for your help