topic Re: How do I merge 2 fields to create a list object in QlikView

How do I merge 2 fields to create a list object

Fri, 21 Nov 2014 10:05:29 GMT

I have 2 fields in a table that I want to merge together so that it can be used as a list object.

I know how to do this with dates i.e. month & year but I cannot get it to work with the fields below.

I have the following in my script:

ApplyMap ('SupplierMap', StockSupplier, 'unknown') as SupplierName,

StockSupplier as SupplierCode,

I want to be able to merge SupplierName and SupplierCode as Supplier so I can select this as a list object meaning I can make multiple selections.

Any help greatly appreciated.

Steve

Re: How do I merge 2 fields to create a list object

mato32188 — Fri, 21 Nov 2014 10:07:47 GMT

ApplyMap('SupplierMap', StockSupplier, 'unknown') & StockSupplier as Supplier

Re: How do I merge 2 fields to create a list object

Anonymous — Fri, 21 Nov 2014 10:10:19 GMT

Below is the Expression

=ValueList($(=concat({1} distinct chr(39) & Col1 & Chr(39),',')),$(=concat({1} distinct chr(39) & Col2 & Chr(39),',')),$(=concat({1} distinct chr(39) & Col3 & Chr(39),',')))

where Col1,Col2,Col3 are column names

Regards

Harsha

Re: How do I merge 2 fields to create a list object

jyothish8807 — Fri, 21 Nov 2014 10:30:31 GMT

Hi Steven

In script try like this:

ApplyMap ('SupplierMap', StockSupplier, 'unknown') & StockSupplier as Supplier

Regards

Re: How do I merge 2 fields to create a list object

Anonymous — Fri, 21 Nov 2014 10:30:36 GMT

Hey,

You can do it in the list box properties. By calculating as expression instead of taking a direct column.

expression = suppliercode&' '&Supplerdescription.

Hope this helps.

Best regards,

Chinna

Re: How do I merge 2 fields to create a list object

Fri, 21 Nov 2014 11:11:39 GMT

Thanks, this has kind of given me what I want but it has broken the rest of the charts in the process.

Re: How do I merge 2 fields to create a list object

Fri, 21 Nov 2014 11:17:39 GMT

This has worked a treat, thanks. Just need to tidy up the data a bit.