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
I tired using the List box but it is not working. what is best way i can exclude?
Can you please help.
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 .
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 * INLINE [
The column X is only necessary for case 2.
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.
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.