topic Re: Use button to select Dimensions in QlikView

Use button to select Dimensions

ZoeM — Sat, 16 Nov 2024 02:25:00 GMT

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?

Re: Use button to select Dimensions

jaibau1993 — Mon, 23 Sep 2019 13:35:35 GMT

Hi!

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

Regards,

Jaime.

Re: Use button to select Dimensions

ZoeM — Mon, 23 Sep 2019 13:54:23 GMT

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?

Re: Use button to select Dimensions

Brett_Bleess — Wed, 02 Oct 2019 14:50:31 GMT

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

Re: Use button to select Dimensions

ZoeM — Thu, 03 Oct 2019 11:33:56 GMT

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!

Re: Use button to select Dimensions

rwunderlich — Thu, 03 Oct 2019 18:45:05 GMT

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

Re: Use button to select Dimensions

ZoeM — Thu, 03 Oct 2019 18:52:09 GMT

Thanks Rob for the insight