topic Re: list box issue in QlikView

list box issue

manoranjan_d — Fri, 15 Jul 2016 07:09:41 GMT

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

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?

Re: list box issue

sunny_talwar — Fri, 15 Jul 2016 07:11:16 GMT

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

Re: list box issue

qlikview979 — Fri, 15 Jul 2016 07:14:18 GMT

Hi Manoranjan,

May be this help full

always selected one value

Re: list box issue

manoranjan_d — Fri, 15 Jul 2016 07:18:43 GMT

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

Re: list box issue

sunny_talwar — Fri, 15 Jul 2016 07:20:50 GMT

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

http://www.learnqlickview.com/alternate-states-in-qlikview/

Introduction to alternate states - The Qlik Fix! The Qlik Fix!

Re: list box issue

MindaugasBacius — Fri, 15 Jul 2016 07:24:02 GMT

Do not duplicate the threads please:

always selected one value

list box issue

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

Re: list box issue

vikramv — Fri, 15 Jul 2016 07:27:08 GMT

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 Tips at QlikShare

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

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

Re: list box issue

manoranjan_d — Fri, 15 Jul 2016 08:10:00 GMT

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

Re: list box issue

manoranjan_d — Fri, 15 Jul 2016 08:22:46 GMT

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

list box issue