topic Re: Current selections box for current sheet only in QlikView

Current selections box for current sheet only

Tue, 01 Oct 2013 07:48:55 GMT

Hi all - I have a bit of an unusaul data model due to customer requirements.

I have sales data split by region and each region has its own table in the data model which is qualified so there are no joins. Then in my application there are several sheets showing the sales by each region. This is so different selections can be made on each region sheet and not affect the other sheets/regions.

The problem I have is the Current Selections box on each sheet is showing the selections across all sheets. I only want it to show the selections that have been made on the sheet the selection box is in.

Is there a way to do this? Or maybe to create a text box or other object to display only the selections on each sheet?

Thanks in advance.

Re: Current selections box for current sheet only

tresB — Tue, 01 Oct 2013 07:58:06 GMT

Try using Alternate State (QV11). PFA for sample

Re: Current selections box for current sheet only

nizamsha — Tue, 01 Oct 2013 08:20:19 GMT

in setting--> document properties-->general tab->alternate state button is there -------->add the alternate state name then go to the sheet add the alternate state name to field

for eg country is the field for that u want to create a alternate state mean put the country listbox first make a copy of country listbox in that give the alternate state name

Re: Current selections box for current sheet only

Tue, 01 Oct 2013 08:23:05 GMT

Thanks both - I will try the alternate states function.