topic Separate (independent) selection in each sheet in QlikView

Separate (independent) selection in each sheet

Wed, 29 Sep 2010 09:35:19 GMT

Hi QV friends,

I have some (maybe basic) questions:

1.) I have some QV project (ver.9.00.7257) and it has a number of sheets. In script are defined some SQL selects (from MySQL database tables).

On first sheet I have following ListBoxes: "Category" (Partneri.KategoriaPartnera), "Subcategory" (Partneri.PodkategoriaPartnera), "Place" (Partneri.Obec), "Name of partner" (Partneri.NazovPartnera).

On second sheet are following ListBoxes: "Name of supplier" (Partneri.NazovPartnera WHERE Kategoria='Supplier'), "Name of buyer" (Partneri.NazovPartnera WHERE Kategoria='Buyer'):

Now I would want in each sheet separate select of parameters. Because now if I select in first sheet some selection, then that selection is automaticaly set in second.

I would want in first sheet make some (manually) selection of data and in second sheet stay empty selection. Means possible make selection independently in each sheets.

thanks for tip

Separate (independent) selection in each sheet

Wed, 29 Sep 2010 09:42:26 GMT

for detail explanation of current state I attach other picture:

...

Separate (independent) selection in each sheet

Wed, 29 Sep 2010 10:51:09 GMT

the one solution will be when activate Tab2 to trigger "save" selections made on Tab1 (via bookmark or variables using macro) and clear selections made on Tab1. After return to Tab1 to apply saved selections.
Is this scenario is ok to post the code?

Separate (independent) selection in each sheet

Fri, 01 Oct 2010 08:33:38 GMT

hi Stefan,

can you write down real solution. I'm affraid that I don't understand your advance.

Separate (independent) selection in each sheet

Mon, 11 Oct 2010 13:33:17 GMT

HI JurajChovan ,

Only thing you have to do for getting different selection for each sheet is,

Assign triggers on activie event of sheet

You can achive these by following steps..

1. Right click on sheet (Make sure you are not clicking on other object)

2. Click on Properties

In triggers tab You can see the "on active sheet" and a button blow that "Add Actions"

3. Click button "Add Actions"

4. Click on Add Button

5. Select Action Type As Selection

6. Select Action as Clear All

7.Click ok

Try your selection

Best wishes

Kaushik