topic List Box filters in QlikView

List Box filters

vinod2086 — Mon, 11 May 2015 06:52:30 GMT

Hi,

i have a list box

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

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

Status

closed

closed by L1

Closed by L2

Is it possible if yes please give me the code

Thanks in Advance.

Re: List Box filters

mato32188 — Mon, 11 May 2015 06:55:32 GMT

Hi,

use wildmatch() in your script editor like:

Load ...

...

From ...

Where Wildmatch(Status, 'Closed*')

Re: List Box filters

Anonymous — Mon, 11 May 2015 06:56:34 GMT

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

Re: List Box filters

qlikviewwizard — Mon, 11 May 2015 07:04:19 GMT

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';

Re: List Box filters

amit_saini — Mon, 11 May 2015 07:10:36 GMT

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

Re: List Box filters

nagarjuna_kotha — Mon, 11 May 2015 07:10:43 GMT

Hi ,

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

Re: List Box filters

happydays1967 — Mon, 11 May 2015 07:11:42 GMT

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,

Re: List Box filters

vinod2086 — Mon, 11 May 2015 07:34:23 GMT

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 ?

Re: List Box filters

qlikviewwizard — Mon, 11 May 2015 07:45:36 GMT

Hi vinod2086

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

Re: List Box filters

Anonymous — Mon, 11 May 2015 08:21:48 GMT

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*');