dropdown input box for variable does not work in the expression

[chriscools]

?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

[sunny_talwar · Accepted solution]

Try like this:

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

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

[chriscools]

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! 🙂