topic Pick(Match()) full string in the Set Analysis in QlikView

Pick(Match()) full string in the Set Analysis

adamjank — Fri, 18 Nov 2016 15:17:41 GMT

Hello,

Before I prepare the whole file to show you what is the issue, I write it here:
I've prepare the variable like these:

vChoice:

pick(match($1, 'Veges','Fruits')

'[Veges] ={"Cucumber"}',

'[Fruits] = {"Bananas"}'

)

Then if I put the variable into the Set Analysis according to the official documents, only errors pops up:
=

=SUM({$ < $(vChoice("Veges")) >} [Spend]) it's no working and got this error 'Error: Error in set modifier expression'

Thanks in advance,
Adam

Gysbert_Wassenaar — Fri, 18 Nov 2016 15:27:10 GMT

Try this:

vChoice:

pick(match($1, 'Veges','Fruits')

[Veges] ={"Cucumber"},

[Fruits] = {"Bananas"}

)

=SUM({$ < $(=vChoice('Veges')) >} [Spend])

sunny_talwar — Fri, 18 Nov 2016 16:10:21 GMT

Try this:

=Sum({$<$(=$(vChoice('Veges')))>} Spend)

Where vChoice

Pick(Match($1, 'Veges', 'Fruits'),

'[Veges] = {"Cucumber"}',

'[Fruits] = {"Bananas"}')

adamjank — Sat, 19 Nov 2016 19:04:04 GMT

Thank you a lot stalwar1!
Extra $(=...) solves the problem!

@gwassenaar‌It doesn't work.