topic Re: List Box Problem in QlikView

List Box Problem

senpradip007 — Mon, 20 May 2013 07:09:41 GMT

Hi Experts,

I have faced a problem. I have one inline table.

_Adock:

Load * Inline [

Field1, Field1_Id

AA, 1

BB, 2

CC, 3

DD, 4

EE, 5

FF, 6

GG, 7

HH, 8

];

I've created two listboxes with same field. What I want, when I select one value "AA" of 1st List box, 2nd listbox would be shown all value of "Field1" except "AA".

Can it be possible?

Please help me to get rid of this problem.

Regards

Pradip

Re: List Box Problem

kumarnatarajan — Mon, 20 May 2013 07:12:31 GMT

Hi,

It is possible. Create alternate states it should be help you.

1. Settings -> Document properties -> general tab -> then you can ableto create alternate state

2. then go to second list box properties. then chage the state. see the below screen short.

Find the attached file

Re: List Box Problem

Mon, 20 May 2013 07:14:21 GMT

use excluded property

right click on the list box select exclude

it helps you

Re: List Box Problem

nizamsha — Mon, 20 May 2013 07:54:22 GMT

got the setting tab in that tab click general tab they u have to click a alternate state ..add the name for the alternate tab eg group1,group2

after that right click the list box in the general tab alternate state will be availabel at the top clikck tht state .eg

group1 for field1 listbox

group2 for field1 listbox

try this one