topic Re: Set attribute in QlikView

Set attribute

Tue, 17 May 2016 12:27:41 GMT

Hi all,

I want to use a function which treat all docnumbers as IC-Type, when a single item in a document number has the type IC.

For example I have this data:

Docnumber, Item, Type

1,1,IC

1,2,#N/A

1,3,3rd

2,1,#N/A

2,2,3rd

2,3,#N/A

Now all Items of Docnumber 1 should be treated as IC-Type, because one Item is equal to type IC.

Thanks!

Joe

Re: Set attribute

sunny_talwar — Tue, 17 May 2016 16:18:51 GMT

May be create a new column where you assign IC to all the repeating Docnumber

Table:

LOAD * Inline [

Docnumber, Item, Type

1,1,IC

1,2,#N/A

1,3,3rd

2,1,#N/A

2,2,3rd

2,3,#N/A

];

Left Join (Table)

LOAD Docnumber,

'IC' as NewType

Resident Table

Where Type = 'IC';

Re: Set attribute

MarcoWedel — Tue, 17 May 2016 23:19:31 GMT

Hi,

maybe helpful:

tabDocItems:

LOAD * INLINE [

Docnumber, Item, Type

1, 1, IC

1, 2, #N/A

1, 3, 3rd

2, 1, #N/A

2, 2, 3rd

2, 3, #N/A

];

tabDocTypes:

LOAD Distinct

Docnumber,

Type as DocType

Resident tabDocItems;

Generic

LOAD Docnumber,

DocType,

'yes'

Resident tabDocTypes;

regards

Marco

Re: Set attribute

Wed, 18 May 2016 07:48:18 GMT

Thanks! It works now perfectly.

Re: Set attribute

Wed, 18 May 2016 07:49:36 GMT

Hi Sunny!

This should also work, but I took the proposal from Marco.

Thanks for your effort!

Re: Set attribute

sunny_talwar — Wed, 18 May 2016 08:09:04 GMT

Not a problem, as long as you get what you were looking for