topic Need Suggestion for Selections in QlikView

Need Suggestion for Selections

aveeeeeee7en — Wed, 05 Mar 2014 20:08:33 GMT

Hi Community

I am Stuck at one place.

I Need different Default Selections on every Sheet even in case the user uses Clear Option, it should show Default Selections but it should be different on each Sheet.

I have 3 Sheets in my Application

Eg.

Sheet 1 : To show 2nd Quarter Default Selection even if the user uses Clear Option

Sheet 2 : To show 2nd Quarter and 1 Status coming from List Box as Default Selection. Even on Clear it should work

Sheet 3 : To Show Max Year

I have used many Alternatives:

Lets Start with 1st one:

S.No.	Sheet Name	Triggers
1	Sheet 1	1) Clear All	2) Select in Field
1	Using 2 Triggers		Field Name: Quarter & Search String: Qtr2
2	Sheet 2	1) Clear All	2) Select in Field	3) Select in Field
2	Using 3 Triggers		Field Name: Quarter & Search String: Qtr2	Field Name: Status & Search String: Active
3	Sheet 3	1) Clear All	2) Select in Field
3	Using 2 Triggers		Field Name: Year & Search String: =Max(Year)

2nd Alternative I have used "Set Clear State"

It is working on All Sheets .

Since when i used Clear, it is showing same default selection for every sheet.

But I want different Default Selections on every Sheet.

So, Can't use Clear Set State.

Any Suggestions?

Regards

Aviral Nag

Re: Need Suggestion for Selections

Wed, 05 Mar 2014 20:58:47 GMT

Hey Nag,

Just a suggestion. Not sure if it fully fits your needs though/or if you have already tried it.

Why don't you clear all when leaving a sheet and when entering a new sheet make your default selection.

So all this to be done in Sheet Properties > Triggers,

Sheet1 when leaving Clear All

Sheet 2 when entering make your default selection

Similarly,

For all the other sheets.

Hope it helps.

Thanks

Re: Need Suggestion for Selections

aveeeeeee7en — Thu, 06 Mar 2014 05:06:37 GMT

Hey Ajay

Thanks for the Logic. It's working.

But I have one Question???

After Applying Triggers on Leave Sheet - Clear All and other Triggers on Activate Sheet, when I am switching to other Sheet, they are working Perfectly as per the Triggers but my area of concern is that I want to show this value even on clear option present in the window above.

Do you have some ideas???

Regards

Aviral Nag

Re: Need Suggestion for Selections

Thu, 06 Mar 2014 06:23:05 GMT

Hi Aviral,

Setting clear state would be one option but as you mentioned it won't work if you need different selections on different sheets. In this case, you might consider creating a clear button on every sheet and then giving specific triggers on that button.

Might not be what you require exactly but just an alternative since clear state can't be set separately for every sheet.

Hope this helps!