topic creating new column based on two others in QlikView

creating new column based on two others

Thu, 29 Sep 2011 14:31:16 GMT

Dears,

I have one problem that I am tackling now and no solution serves it right, although probably it is very simple. Maybe you can help?

From two different sources I have two fields [Vendor name] and [Trading partner name] that are already mapped into one table.

Data looks now like this:

doc. Vendor name Trading partner name

1 a

2 b

3 c

4 d

5 e

I would like to get data like this:

doc. Vendor name Trading partner name Vendor_final

1 a a

2 b b

3 c c

4 d d

5 e e

The following solutions do not work for sure:

if([Trading partner name]='',[Vendor name], [Trading partner name]) as Vendor_final,

if([Trading partner name]<>'' and [Vendor name] ='',[Trading partner name], if([Trading partner name]='' and [Vendor name] <>'',[Vendor name],'vendor not found'))
as Vendor_final

I will be grateful for any tip.

creating new column based on two others

SunilChauhan — Thu, 29 Sep 2011 14:35:43 GMT

everywhere give spacelike below ex:' ' in place of ''

if([Trading partner name]=' ',[Vendor name], [Trading partner name]) as Vendor_final

hope this solve your problem

creating new column based on two others

Thu, 29 Sep 2011 14:40:40 GMT

It seems not to help. This function results in a Vendor_final column that has only [Trading partner name] as data; [Vendor name] data is not included.

Re: creating new column based on two others

its_anandrjs — Thu, 29 Sep 2011 14:42:34 GMT

Hi,

I think you have to use

If( isnull( [Vendor name]) = -1,[Trading partner name] , [Vendor name] ) as Vendor_final

Rgds

Anand

creating new column based on two others

Thu, 29 Sep 2011 14:45:35 GMT

Thank you. That works fine:)