always selected one value

[manoranjan_d]

Hi all

In sheet 1 i have list box of dept where that has to be always selected one value

now when i move to sheet 2 the always selected one value has to be cleared

how can we achieve this.

[vikasmahajan]

Step 1 . for Sheet1  Go Sheet Properties  -> Trigger -> On Activate -> Select in Field -> Select Field -
>Give Search Value

Step 2 . for Sheet2  Go Sheet Properties  -> Trigger -> On Activate -> Select in Field -> Select Field -

>Give Search Value

Hope this helps you

Vikas

[vikasmahajan]

[manoranjan_d]

this is not the correct one, bcoz when i m movig to sheet2 there is no dept dept list box.

[vikasmahajan]

additional action also you can add in this box while leaving sheet clear -> Field -> Dept

[vikramv]

Oops fort to attach the screenshot...

You have to write a macro as mentioned in the below link:

How to clear the Always One Selected Value ListBox Property - QlikView Blog, QlikView Videos and Tip...

In the first sheet use the attached option of list box.

Then use this macro in same sheeet triggers OnLeave Sheet -->  ACtions -- > Extrenal --> Run Macro as per link above

or

As an alternative , We can use Alternative states to achive this kind of functionality.

Like You have to keep all the objects of that particular sheet a particular alternative state and all other sheets in normal state..

Hope this helps !

[MindaugasBacius]

In sheet2 use trigger Clear Field

[jayaseelan]

Hi Manoranjan,

Hope this will help you.

[manidhana90]

Hi Manoranjan,

Try to use Alternate state for sheet1's objects,

Refer this, Alternate States selection in default chart

[manoranjan_d]

but as per the requirement it should have only one value to be selected in the list box, not more than one