topic Re: List box selection conditionaly in QlikView

List box selection conditionaly

stephenedberkg — Tue, 25 Aug 2015 07:06:37 GMT

i have the list box1 it contain product, salesman and area this list box content are loaded by In-line script.

if i select the product in list box1 i want to show the list box of product (it is another list box)

if i select the salesman i want to show the list box of salesman (it is another list box)...

How can i achieve this help me

Thanks in advance

Re: List box selection conditionaly

sujeetsingh — Tue, 25 Aug 2015 07:17:38 GMT

Just use trigger on Fileds.

-Go to >> Document Properties

- Triggers Tab
- Go for the required field in Field event Trigger

Then you can write the action on On Select to activate each List boxes.

Re: List box selection conditionaly

vardhancse — Tue, 25 Aug 2015 07:18:53 GMT

So, you want to see related data for one selection in one list box in another list box, then we need to join the tables as per our requirement.

Once see the data model may be tables may not be joined if at all 3 fields were from 3 different tables

Re: List box selection conditionaly

stephenedberkg — Tue, 25 Aug 2015 07:20:14 GMT

can you explain about detaily

Re: List box selection conditionaly

gautik92 — Tue, 25 Aug 2015 07:30:23 GMT

try to use trigger on select to show list boxes

Re: List box selection conditionaly

ChennaiahNallani — Tue, 25 Aug 2015 07:30:30 GMT

Go to Document Proprieties select Triggers and select your field name (witch you want select field) in field event triggers, click on "On Select" Button.

Select Add->layout->Active Object and Give Object ID(witch you show list box ID)

Re: List box selection conditionaly

maxgro — Tue, 25 Aug 2015 07:30:54 GMT

if I understand, see attachement

Re: List box selection conditionaly

stephenedberkg — Tue, 25 Aug 2015 08:00:09 GMT

not one object based on selection i want to show the list box

Re: List box selection conditionaly

stephenedberkg — Tue, 25 Aug 2015 08:00:46 GMT

i am using trial version can you share the procedure

Re: List box selection conditionaly

sujeetsingh — Tue, 25 Aug 2015 08:42:41 GMT

Stephen,

You have to follow the reference manual for triggers.

Actually how it works is we set action for a field. Let there be Inline Field as Field1. Here Field1 has value Product,SalesMan and Area. Now you also have separate fields as

Product = Values of product can be Shirt,Belt etc

SalesMan = Ram,Jhon,Rahim etc

Area = Delhi,Bombay,City road etc

You have called these fields in separate list boxes. Now you have ListBox with Field1 which has 3 values Product,SalesMan and Area. Now in triggers you have to write action. use External action"Set Variable'

Create a variable vListBox (you should know how to create).

In actions value expression write:

if(getfieldselection(Field1)='Product',1,if(getfieldselection(Field1)='Area',2,if(getfieldselection(Field1)='SalesMan',3)))

Now on each List boxe for Product write Show conditional as

if(vListBox=1,1,0)

Now on each List boxe for SalesMan write Show conditional as

if(vListBox=3,1,0)

Now on each List boxe for Area write Show conditional as

if(vListBox=2,1,0)

Re: List box selection conditionaly

stephenedberkg — Tue, 25 Aug 2015 09:51:53 GMT

i tried but

if i selected the field (i mean list box) related list box is not show. its only hide

Re: List box selection conditionaly

gautik92 — Tue, 25 Aug 2015 09:53:42 GMT

try creating trigger it will be more easy

Re: List box selection conditionaly

stephenedberkg — Tue, 25 Aug 2015 09:58:11 GMT

hello already i created but i cant get

Re: List box selection conditionaly

stephenedberkg — Tue, 25 Aug 2015 10:00:32 GMT

sujeetsingh

Re: List box selection conditionaly

sujeetsingh — Wed, 26 Aug 2015 04:34:28 GMT

WELCOME SIR