Grouping

[#1]

hi ALL,

Iam attaching the QVW fiel if u look in Main, u see that i have a straight table over there , which has type column  .

under TYPE column i want to  bring the Projects , I have also created the Inline Load , but this will not full fill my requirement , hence iam tryying to group the contenet of the TYPE and then  name those contenet as Projects .

I had created  a QVW which had a table called booking under this table

i had grouped the names like below .

if(match([A/c assign.],'01'), 'Traded Products',

        if(match([A/c assign.],'02'), 'MFG Products',

           if(Match([Sales Order Type],'ZINS'),'Installation','Others'))) as TYPE,

And the output is like this :

Type

Traded Products

MFG Products

Installation

Others.

After this i created the QVD of Booking table ,

Now under QVD  i want to group the TYPE column which iam doing like this

    if(match(TYPE,'Traded Products'),'Traded Products',

    if(match(TYPE ,'MFG Products'),'MFG Products',

     if(match(TYPE ,'Installation') ,'Installation',

   if(match(TYPE ,'Others'),'Others')))as Projects,

after grouping when i try to load its not working and giving the error as Expression error.

Can someone plz let me know how do i do this

[anbu1984]

Can you post your script?

Why do use the below expr? You can directly rename field like "TYPE as Projects"

if(match(TYPE,'Traded Products'),'Traded Products',

    if(match(TYPE ,'MFG Products'),'MFG Products',

     if(match(TYPE ,'Installation') ,'Installation',

   if(match(TYPE ,'Others'),'Others')))as Projects,

[#3]

Hi anbu,

Actaully iam using a straight table i cannot rename TYPE as Projects because i want the project to be under type.

thas why iam trying to do this

iam posting my QVW , in that  u will undersatnd what i want to chieve if u see in MAIN,

to bring Project under TYPE i created INLINE load , but its not working thats why i want to group the content of TYpe and rename it as Projects

[anbu1984]

I am using PE. Can you post your script.

[Peter_Cammaert]

I think the expression error is caused by a missing right parenthesis. You have four nested IF's. Shouldn't there be four right parentheses before the ...AS Projects column specifier?

  if(match(TYPE,'Traded Products'),'Traded Products',

     if(match(TYPE ,'MFG Products'),'MFG Products',

        if(match(TYPE ,'Installation') ,'Installation',

           if(match(TYPE ,'Others'),'Others'))) as Projects,

[maxgro]

=pick(match(TYPE, 'Traded Products', 'MFG Products',  'Installation', 'Others'), 'Traded Products', 'MFG Products',  'Installation', 'Others')