topic Re: Need some information in QlikView

Need some information

Anonymous — Thu, 02 Apr 2015 05:50:20 GMT

I have three sheets ,each sheet has two list boxes . when i make a selection on one list box the associated data on the other list box gets selected ,and same will be repeated for all the sheets .

Now , i want to make selection should be effected on only sheet1 and other sheets should not get effected with selection of list boxes .

Any help will be appreciated

Thanks in Advance

Re: Need some information

Anonymous — Thu, 02 Apr 2015 05:52:56 GMT

Create Alternate States

and assign

State1 for objects on sheet1

State2 for objects on sheet2

State3 for objects on sheet3

Re: Need some information

Anonymous — Thu, 02 Apr 2015 06:00:58 GMT

Is there any way other than alternate states .???

Re: Need some information

sushil353 — Thu, 02 Apr 2015 06:02:58 GMT

Hi,

You can apply trigger of Clear field on activating the sheet..

HTH

Sushil

Re: Need some information

sujeetsingh — Thu, 02 Apr 2015 06:13:59 GMT

There are two ways to handle this

> Fist one to add action on sheet

One can set action of clear all on Leave for a sheet or tab. You can get the option from the sheet properties

> Second way is the Alternate states

You can set alternate states and use each for each tab

Now both the ways have some pros and cons now you need to follow any one of them according

Re: Need some information

sujeetsingh — Fri, 03 Apr 2015 09:53:04 GMT

@rgv rand Please mark this thread with proper status.

Re: Need some information

Fri, 03 Apr 2015 10:03:21 GMT

Hey Rgv Rand, yes its possible as Bhagirath stated with the same method below:

Create Alternate States

and assign

State1 for objects on sheet1

State2 for objects on sheet2

State3 for objects on sheet3

Keep posting such informative posts. I am from www.SIMpalm.com , a leading mobile app development company in USA.

Re: Need some information

mightyqlikers — Fri, 03 Apr 2015 10:07:10 GMT

Hi rgv,

you can put sheet triggers , like when sheet is active clear that filed

like this.

Thanks & Regards
Samwise

Re: Need some information

Fri, 03 Apr 2015 10:40:44 GMT

Create 3 different alternate sheet with three name in Settings-->Document properties--->Alternate state and assign it in each sheet properties.

All three sheets will work independently.

Thanks,

sampath

Re: Need some information

maxgro — Tue, 28 Apr 2015 20:47:59 GMT

maybe with 2 trigger for every sheet and 3 bookmarks

- apply bookmark on activate

- replace bookmark on leave