topic Selecting chart dimensions with a listbox in QlikView

Selecting chart dimensions with a listbox

markp201 — Mon, 19 Feb 2018 10:49:54 GMT

I tried the cyclical but didn't care much for the interaction and thought of doing using a listbox

to select the dimension. The measure is the same regardless but couldn't get it to work

correctly. I figured the listbox would be simply "Store Product", "Product Group", "Store", etc.

I also tried DSE to return =[Store Product], [Store Product], etc but nothing would work.

I've seen the example enabling a preset dimension but that looked heavy on the maintenance.

Is there a simpler solution?

sunny_talwar — Mon, 19 Feb 2018 12:32:10 GMT

Have you looked here already?

markp201 — Mon, 19 Feb 2018 13:29:36 GMT

Thanks for the link but what about =$('[' & [_Dimension] & ']') for the calculated dimension?

It doesn't work but seems like it should.

sunny_talwar — Mon, 19 Feb 2018 13:37:24 GMT

You are missing an equal sign

$(='[' & [_Dimension] & ']')