topic Re: Multiple dynamic dimensions in QlikView

Multiple dynamic dimensions

Thu, 03 Jul 2014 13:26:02 GMT

I am trying to create a line graph with two sets of dynamic dimensions. Each set is identical and consists of 40 dimensions. One dimension will be on the x axis and the second should determine the colour of each line. Due to the number of dimensions, they must be in a drop down box format for the user to select from i.e. not buttons.

So far the only way I have found to do this is to load two inline tables with the dimension names (I have also tried assigning numbers instead), with two calculated dimensions in the chart that have if statements for each dimensions.

Besides this being highly manual, I keep getting a memory error and if the chart does work then it is terribly slow to load.

Is there a more elegant solution for this?

Thanks
Roshny

Re: Multiple dynamic dimensions

Gysbert_Wassenaar — Thu, 03 Jul 2014 13:38:54 GMT

The inline tables are good. Make sure the listboxes are set to Always One Selected Value. You can the use as calculated dimensions like: =$(='[' & ListboxFieldA & ']')

See attached qvw

Re: Multiple dynamic dimensions

Thu, 03 Jul 2014 13:45:22 GMT

Hi Gysbert

I can't use a listbox as there is no dropdown select option so I have had to use a table box which doesn't give that option.

Regarding the calculated dimension, what should ListboxFieldA represent? Is there some sort of variable I need to create?

Thanks for the help.

Roshny

Re: Multiple dynamic dimensions

Gysbert_Wassenaar — Thu, 03 Jul 2014 13:46:53 GMT

Use a multibox instead of a listbox. The principle stays the same.

ListboxFieldA was the field name you would have used in one of the two listboxes. Now it is the name of the field you use in a multibox. See the document attached above for how I used a field with the name MyField.

Re: Multiple dynamic dimensions

Thu, 03 Jul 2014 14:08:10 GMT

Thanks so much - that worked a treat!