topic Re: help on list box in QlikView

help on list box

manoranjan_d — Thu, 12 Mar 2015 11:30:47 GMT

Hi,

I have given example below

table box

serialnum value2 value3

1111 xxx xxx

2222 xxx xxx

3333 xxx xxx

444 xxx xxx

23424 xxx xxx

6666 xxx xxx

345345 xxx xxx

xxx xxx

7777 xxx xxx

3455 xxx xxx

xxx xxx

above one shows the table box and it contains serialnum, value2 and value3 fields.

note: serialnum filed have some blank value.

the blank value in the serialnum are good rec and value which contains in serialnum are bad record.

example(1111, 2222,) are bad rec.

i created separate list box for this good rec and bad rec.

below is the dynamic expression i used for good rec list box

=if(len(serialnum)= 0 ,'Good Records')

when i click the good rec list box first time it got selected and its shows the good rec in table box, afterwards when i click the same good rec list, the selected item is released in table box. so this one working fine and good.

but when i used the expression in bad rec list box its not working fine

=if(len(serialnum)>0,'bad record').

when i click the bad rec list box first time it not selected and it get changed and shows the correct bad rec in table box, afterwards when i click the same bad rec list, the selected item is not released in table box. so i m having issue in this bad rec.

please help me on the bad rec expression.

Re: help on list box

jonathandienst — Thu, 12 Mar 2015 11:37:08 GMT

The null values are not selectable - you are trying to select them indirectly, and I think that may be part (or all) of your problem.

In the load script make the null values selectable, use

NULLASVALUE serialnum;

before loading serialnum. Or replace the null values of serialnum in the load:

LOAD....

If(Len(serialnum) = 0, 'Missing, serialnum) As serialnum,

...

HTH

Jonathan

Re: help on list box

PrashantSangle — Thu, 12 Mar 2015 11:43:31 GMT

Hi,

Did you create two different list box??

just try with one list box

In script write

if(len(trim(serialnum))=0,'Good','Bad') as GB_Flag

Use GB_Flag in Front end and try it.

Regards

Re: help on list box

manoranjan_d — Thu, 12 Mar 2015 12:17:37 GMT

correct thanks to jonathan dienst max dreamer