topic Exclude required values in List Box in QlikView

Exclude required values in List Box

Anonymous — Sat, 29 Aug 2015 18:41:28 GMT

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

Re: Exclude required values in List Box

agni_gold — Sat, 29 Aug 2015 19:15:45 GMT

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 .

Re: Exclude required values in List Box

agni_gold — Sat, 29 Aug 2015 19:21:27 GMT

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

Re: Exclude required values in List Box

petter — Sat, 29 Aug 2015 19:23:12 GMT

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.

Re: Exclude required values in List Box

qlikviewwizard — Sun, 30 Aug 2015 03:17:52 GMT

Hi,

Please check these threads.

Exclude unwanted values from calculated dimension

Re: Exclude required values in List Box

Anonymous — Sun, 30 Aug 2015 12:25:21 GMT

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

Re: Exclude required values in List Box

qlikviewwizard — Thu, 03 Sep 2015 10:42:41 GMT

Hi,

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

Re: Exclude required values in List Box

Anonymous — Fri, 04 Sep 2015 13:05:44 GMT

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

Re: Exclude required values in List Box

qlikviewwizard — Fri, 25 Sep 2015 10:05:21 GMT

Hi Reddy,

Can you attach some sample data?