List Box filters

[vinod2086]

Hi,

i have a list box

Status
closed pending approved closed by L1 Closed by L2 Pending from L1

but in my requirement is status list box should display only closed ,closed by L1 and Closed by L2.

Status
closed closed by L1 Closed by L2

Is it possible if yes please give me the code

Thanks in Advance.

[mato32188]

Hi,

use wildmatch() in your script editor like:

Load ...

...

From ...

Where Wildmatch(Status, 'Closed*')

BR

M

[Anonymous]

Hi,

Add an expression in the general tab of your listbox as follows

if(match(Status,'closed','closed by L1', Closed by L2'),Status)

Regards,

Greeshma

[qlikviewwizard]

Hi vinod2086,

Use the code as below

Table:
LOAD * inline [
Status
closed
pending
approved
closed by L1
Closed by L2
Pending from L1
]
where Status='closed'or NAME ='closed by L1' or NAME ='Closed by L2';

[amit_saini]

Vinod,

You can do this by two ways:

Front side:

=if(match(Status,'closed' ,'closed by L1' ,'Closed by L2' ),Status)

Script Side :

Where match(Status,'closed' ,'closed by L1' ,'Closed by L2') ;

Thanks,
AS

[nagarjuna_kotha]

Hi ,

In Which end you want.Front end or back end ?

[happydays1967]

HI,

Both above answers are valid, it just depends on what you want.... Do you want to include the data but just not be able to filter on it, then use the expression (very last option in the field list of the list box) and then enter the expression  like Greeshma suggested. If you don't want to see data at all, then exclude it in your script.

Regards,

HP

[vinod2086]

Hello Thanks for all of you

actually my requirement is different i have created one Report in that report i have used more than 5 sheets for example

i have 2 sheets one is for closed and another is pending reports here i used straight table i has applied expression now i can see closed and pending reports separately this is fine but when i select list box by default it displaying all values but i don't want to display all values for closed report Status  list box should display only closed, closed by L1 And so on

same as pending report

is it possible ?

[qlikviewwizard]

Hi vinod2086

Please Close this thread and start the new thread for new question.

[Anonymous]

Hi Vinod,

Please refer the following code,

Tab1:

LOAD * Inline [

S.No,Status

1,Closed

2,Pending

3,Approved

4,Closed by L1

5,Closed by L2

6,Pending from L1

];

Tab2:

LOAD Status as Place

Resident Tab1 Where WildMatch(Status,'Closed*');