Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
?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
Try like this:
Count({<[ProductCollectionCode] = {'$(=vSeizoenArtikel)'}>} SkuCode)
Update: Also added the single quotes around the dollar sign expansion
Try like this:
Count({<[ProductCollectionCode] = {'$(=vSeizoenArtikel)'}>} SkuCode)
Update: Also added the single quotes around the dollar sign expansion
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! 🙂