topic Re: Hide current selections in a tab in QlikView

Hide current selections in a tab

venkatg6759 — Tue, 24 Sep 2013 13:59:01 GMT

Hello,

Is there a way where we can hide current selections and show the entire data in a tab without taking the previous selections in another tab?

MayilVahanan — Tue, 24 Sep 2013 14:10:58 GMT

You can exclude that selection by using set analysis like

=Sum({<Year=>}Sales) // it excludes the year selection

Sum({1}Sales) // it excludes all selection

Andrea_Ghirardello — Tue, 24 Sep 2013 14:14:58 GMT

Try using bookmarks.

See attached qvw in the following discussion:

yavoro — Tue, 24 Sep 2013 14:21:21 GMT

Hi, the only thing I can think of is to clear all selections when you go to this tab.

You can set up an action in tab triggers for that.

Hope that helps.

Regards

Tue, 24 Sep 2013 14:25:55 GMT

If you go to the sheet properties of the tab.

And toy choose the tab triggers.

You can add an action to OnActivateSheet.

From selection just add Clear All and all selections will be dropped

venkatg6759 — Tue, 24 Sep 2013 14:30:42 GMT

Thanks Erik. It worked perfectly.