topic Re: Object Specific Default selection in QlikView

Object Specific Default selection

Anonymous — Thu, 20 Mar 2014 13:31:53 GMT

Hi GUYS,

Can anyone help with object specific default selection.

I have six charts in a sheet(minimized state), but I want default selection for only three charts, when i click to other charts those selection should be cleared.

Re: Object Specific Default selection

Gysbert_Wassenaar — Thu, 20 Mar 2014 13:36:39 GMT

You can add alternate states to your document if you're using QV11 or newer. You can add those on the General tab of the document properties window. After creating them you can assign them to sheet objects on the General tab of the objects properties window. Selections in one alternate state don't influence selections in other alternate states or the default state. This way you can make sheet objects react only to a specific set of selections, those made in a specific alternate state.

Re: Object Specific Default selection

Anonymous — Thu, 20 Mar 2014 13:54:00 GMT

is there any other work around for this problem?as user can not go and change the states they want us to set likewise

Re: Object Specific Default selection

Gysbert_Wassenaar — Thu, 20 Mar 2014 14:01:51 GMT

You can try using bookmarks. That makes it easy to save and restore selections. However if you don't use alternate states there is only one selection state (at a time) in your document and it will apply to all sheet objects.

Re: Object Specific Default selection

MarcoWedel — Thu, 20 Mar 2014 22:15:14 GMT

Hi Rajashmita,

you could use triggers and actions i.e. when entering different sheets, that hold the specific charts.

e.g the trigger OnActivateSheet of one sheet could have the actions "Selection/Select in Field" with Field an Searchstring defined per field.

The OnLeaveSheet trigger could clear all selections using the action "Selection/Clear All".

Hope this helps

regards

Marco

Re: Object Specific Default selection

Anonymous — Fri, 21 Mar 2014 03:23:58 GMT

ya Gysbert, I can use bookmark in the expression but i have that field as dimension in the chart,so it will display other values also that are not selected.

Re: Object Specific Default selection

Anonymous — Fri, 21 Mar 2014 03:25:06 GMT

Could you please share any example how using trigger I can apply particular selection to specific charts in a sheet?

Re: Object Specific Default selection

Anonymous — Fri, 21 Mar 2014 03:45:48 GMT

On activate sheet whatever action we apply it will be applied to all objects on that particular sheet, not specific object

Re: Object Specific Default selection

Fri, 21 Mar 2014 03:49:22 GMT

Rajashmita,

Please post a sample app to help us understand your requirement better.

Re: Object Specific Default selection

Anonymous — Fri, 21 Mar 2014 03:59:11 GMT

In the above picture When I select Student as Gopi that is affecting both Charts(Mark Details and Category),But I want only one chart should have that default selection .With applying sheet trigger on open I want Student as Gopi should be selected by default for the Mark Details alone.

Re: Object Specific Default selection

Fri, 21 Mar 2014 05:24:14 GMT

Hi,

Check the atatched one.

Re: Object Specific Default selection

rwunderlich — Fri, 21 Mar 2014 05:31:35 GMT

As Gysbert mentioned, the Alternate States feature may address your requirement.

Use Alternate States if you want to maintain two independent sets of selections.

Use Set Analysis if you want an expression to ignore selections in a field

{<Student=>}

-Rob

Re: Object Specific Default selection

sundarakumar — Fri, 21 Mar 2014 05:37:31 GMT

Rajashmita,

I think Alternate state is teh best option for ur problem...

Create on open triggers on the particulat alternate state which is used in the chart that needs the selection to be made..

-Sundar

Re: Object Specific Default selection

sunilkumarqv — Fri, 21 Mar 2014 05:47:39 GMT

Hi Rajashmita,

Consider you make default selection when open the document or sheet of particular field

assume that you have list box a c b d... here you want make default selection is c then

go to sheet properties -Triggers -On Activate-Add actions -add- Selection- select in field -Field name means you list box name and in Search String should be like 'c' .

then use clear all OnLeaveSheet .

If any clarifications let us know so that it easy for you