topic Pick Dimensions in QlikView

Pick Dimensions

dseelam — Sat, 16 Nov 2024 00:32:57 GMT

Hello All,

I created a straight table with 10 dimensions and 5 measures and also I created a list box where I can pick dimensions what to show on straight table successfully, but now I would like to default straight table to 1 dimension when I open dashboard before even I start picking selecting anything on straight table is this possible if yes how I can achieve this.

Thanks,

Re: Pick Dimensions

vamsee — Thu, 04 Jun 2020 02:44:43 GMT

Probably create a trigger

Settings--> Document Properties --> Triggers --> On Open --> Actions --> Select in field --> Field Name, Value

You can also try Always one selected value in the list box to make sure one dimension is always selected.

Re: Pick Dimensions

Brett_Bleess — Thu, 25 Jun 2020 21:01:02 GMT

Beware the OnOpen trigger is an unsupported trigger in the Ajax client, so that may not work/be supported should you have issues. The easier solution is to just save the application as you want it to be set when it opens on the Server, every user will start at that location. If you allow Session Recovery in your environment, then after the initial opening, the user will always return to their last state of their last session. Publisher will reset things post reload before distributing the updated application too.

Regards,
Brett

Re: Pick Dimensions

vamsee — Thu, 25 Jun 2020 21:12:00 GMT

Thanks @Brett_Bleess , I didn't know that On Open triggers won't work on the Ajax client, will have to play around and check.

Re: Pick Dimensions

Brett_Bleess — Thu, 25 Jun 2020 21:16:31 GMT

Check the following Help link, there is a statement on the OnOpen trigger regarding it being unsupported in Ajax, it may work, but it is unsupported, that is why I wanted to point that out, as if folks call in later, that is the first thing we will point out to them.

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Document_Properties_Triggers.htm

The same goes for the Actions, there are some that are unsupported for Ajax, only a few at this point I believe, but there are some...

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Button2.htm#anchor-4

Cheers,
Brett