Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Exclude required values in List Box


Hello,

I have about 2000 product ids and i want to exclude  about 150 product ids and display in the list box. I dont want to exlcude in the load script.

I have about 2000  Prod Ids with values as below: 1011,1021,2012,2034,,2045,2043,3012,4051,5023,6786,9025,4057,1018,2038,4098,7098................................

i want to exclude 150  Prod id  as given below

2012,4051,6786,4098 ..........

I tired using the List box but it is not working. what is best way i can exclude?

Can you please help.

Regards,

Paul

8 Replies
agni_gold
Specialist III
Specialist III

Is there any rule to exclude these product id .

If Yes then you can use the Flag in Backend Script and Use that flag in your expression in front end.

Please tell whatever rule is there and send sample application .

agni_gold
Specialist III
Specialist III

Create new field in your load script with condition which remove the product ID

petter
Partner - Champion III
Partner - Champion III

You can use a flag in your product table or you can use an explicit Match(). Either way you specify an expression in your list box to enable the filtering:

1) =If( Match( T , '1','5','8','9') , Null() , T )

2) =If( X = 0 , Null() , T )

Load Script:

T1:

LOAD * INLINE [

T, X

1, 0

2, 1

3, 1

4, 0

5, 1

6, 1

7, 1

8, 1

9, 0

10,1

];

The column X is only necessary for case 2.

qlikviewwizard
Master II
Master II

Anonymous
Not applicable
Author

Paul,

In a situation where the number of values to exclude is high, and there is no rule, I'd rather keep the values to exclude in a separate data soure (database table, flat file).  This will allow to create a field of the "not-excluded" values in addition to the field with all values.  Although you say you don't want to do it in the script, this is the best way.
A compromise is'to use flags based on the same data source of the excluded values, but I don't see why I'd do it if I'm changing the script anyway.
The only way to avoid any script changes is a calculated dimension with set analysis where you list all values you want to exclude.  I do not recommend creating suc a monster.

Regards,
Michael

qlikviewwizard
Master II
Master II

Hi,

Did you able to manage to get your required solution? Thank you.

Anonymous
Not applicable
Author

Hi

I didnt get the solution yet.

I have A to Z , AA,

AB, AC..........AZ Values as Prod id. I have excluded M & N Values in the Load script.

I  needed A& B values  in Sheet1 and have selected only A & B  value of Prod ID using expression field . I have selected  B & C using Expression in Sheet 2. Now i want to exclude A to Z in Sheet3 and have rest (for example AA, AB..... ZZ)

Can you please help how can i get the same.

Regards,

Paul

qlikviewwizard
Master II
Master II

Hi Reddy,

Can you attach some sample data?