list box issue

manoranjan_d · ‎2016-07-15

Hi all,

in sheet 1 i have dept list box where and also as per the requirement in the list box only one value has to be selected not more than one

so i gave always selected one in the list box

example:

dept list

cse

it

ece

now i m moving to the sheet 2 there is no list box, but the always selected one value in the sheet1 list box is getting reflected in the sheet2 ,

so always selected one value has to be cleared when i move to sheet 2?

sunny_talwar · ‎2016-07-15

I guess you will need to use Alternate States in this case to get this to work

qlikview979 · ‎2016-07-15

Hi Manoranjan,

May be this help full

manoranjan_d · ‎2016-07-15

i fi i use then in current selection box it will have the selection? i wan to clear the current selection when i move.

macro is not allowed due to performance issue

sunny_talwar · ‎2016-07-15

That is why I proposed Alternate States. Are you familiar with the concept of Alternate State? If not, then look here:

MindaugasBacius · ‎2016-07-15

Do not duplicate the threads please:

Delete one of them as it is complicated to follow up.

vikramv · ‎2016-07-15

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

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..

manoranjan_d · ‎2016-07-15

sunny i set two alternate state such that list1 and list 2

i have assigned the list 1 to the sheet1 and list2 to the sheet2.

but its not removing the current selections

manoranjan_d · ‎2016-07-15

sunny i set two alternate state such that list1 and list 2

i have assigned the list 1 to the sheet1 and list2 to the sheet2.

but its not removing the current selections

Related Topics