This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I have designed a master item (dimension) with three dimensions:
=pick(match(vDimension, [Konto.IdDesc], [Ansv.DivisionIdName], [Kontogrupp]), 'Konto', 'Cost Center', 'Kontogrupp')
Definition of Variable VDimension: [Konto.IdDesc]
But a listbox through a straight table with vDimension as Dimension doesn't work. Where is the problem? Anything missing?
Any ideas? Many thanks for your help.
correction: the listbox has the master item "cyclic dimension" as dimension.
Not sure what exactly you are trying to achieve but you might need to format it something like this -
=pick(match('$(vDimension)', '[Konto.IdDesc]', '[Ansv.DivisionIdName]', '[Kontogrupp]'), 'Konto', 'Cost Center', 'Kontogrupp')
thank you, that helped a bit. Now I am able to see "Konto" in the list box, but not the other two dimensions.
I would like to get the same as in this video, up to min 3 everything is told...
Any ideas how to fix this?
I think you missed using $Field system field in your master dimension, I suggest you watch it from the beginning and update your master item as below -
=pick(match($Field, 'Country','City','Shipper'),'Country Name','City Name','Shipper Name')
I had to single quote $field to get a correct syntax.
Furthermore I have defined these variables:
vCyclicDimension: if(len('$(vCyclicValue)')>0, '$(vCyclicValue)', '[Konto.IdDesc]')
Finally I am getting $field instead of the requested dimensions (Konto.IdDesc, Ansv.DivisionidName, Kontogrupp).
I went through the video many times, but not getting the right results. Any ideas?