topic Grouping in QlikView

Grouping

Tue, 10 Feb 2015 04:28:33 GMT

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

Re: Grouping

anbu1984 — Tue, 10 Feb 2015 04:31:56 GMT

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,

Re: Grouping

Tue, 10 Feb 2015 04:39:05 GMT

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

Re: Grouping

anbu1984 — Tue, 10 Feb 2015 04:54:53 GMT

I am using PE. Can you post your script.

Re: Grouping

Peter_Cammaert — Tue, 10 Feb 2015 07:48:59 GMT

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,

Re: Grouping

maxgro — Tue, 10 Feb 2015 08:13:27 GMT

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