dropdown input box for variable does not work in the expression

chriscools — Wed, 04 Jan 2017 21:49:33 GMT

?Hello,

i use an expression in an inputbox to define the list of possible values for a variable (= vSeizoenArtikel) like this:

=(concat( DISTINCT ProductCollectionCode , ','))

If i do it like that, then i get 1 long string instead of a dropdown.

Now i found here that i needed to replace the comma with a semicolon like this: =(concat( DISTINCT ProductCollectionCode , ';'))

And then i do get a dropdown to choose my variable.

But when i try to use the variable in an an expression: Count ( { <[ProductCollectionCode]={$(vSeizoenArtikel)} >} SkuCode)

Then the expression does not work and i get this error displayed in the graph:

"Error in set modifier ad hoc element list: ',' or ')' expected"

So it seems i'm stuck: if i use a comma then it gives me 1 string and not seperate values, and if i use a semicolon it expects a comma.

And i know that the expression in the graph is ok, because if i type in manually one of the possible values like this: 'Summer 2017'

Then the graph works...

Does anybody have a clue how i might fix this?

thanx!

Chris

Re: dropdown input box for variable does not work in the expression

sunny_talwar — Wed, 04 Jan 2017 22:10:45 GMT

Try like this:

Count({<[ProductCollectionCode] = {'$(=vSeizoenArtikel)'}>} SkuCode)

Update: Also added the single quotes around the dollar sign expansion

chriscools — Wed, 04 Jan 2017 22:17:42 GMT

Super, thanx!

Appareantly only the single quotes were ok! it works with and without the equal sign.

No i can go to sleep in peace! 🙂