Use button to select Dimensions

[ZoeM]

Hi Community.

Hey I have an interesting one today. It should be simple enough but Im stumped. 

Can one create an action that selects dimensions?  

I have 26 dimensions and I want to create a button (or use text object) that when clicked it will select only desired dimensions and so forth. 

Is that possible?

[jaibau1993]

Hi!

There is an action to "Select in Field". You may use it!

Regards,

Jaime.

[ZoeM]

Thanks Jaibau

Yes but I have to specify what to select in the field where in this case I want only that dimension to be showing in the chart.

I have noted one workaround is to give each dimension a variable and then create buttons based on the variable value.

I thought there would have been an alternative?

[Brett_Bleess]

Zoe, are you referring to something like choosing which dimensions to use in a chart etc.?  Need some further info on the use case on this one I think in order for folks to be able to try to guide you on possible ways of doing things.

Regards,
Brett

[ZoeM]

Thanks Brett. I will try to be a bit more specific.

So currently in Qlik we have Select In Field which allows us to select something within one of the dimensions. But in this case I want to select dimension as a whole and not just a value within a specified dimension. 

Is this currently possible in Qlik without specifying a variable and using show/hide condition?

Thanks team!

[rwunderlich · Accepted solution]

Load your Dim fieldnames into a field, for example, "SelectedDim".  Then code your chart dimension as:

=$(=MinString(SelectedDim))

Make a listbox for SelectedDim. 

See attached example. 

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

[ZoeM]

Thanks Rob for the insight