topic Re: Combine fields in QlikView

Combine fields

Tue, 27 Nov 2012 15:41:12 GMT

How to combine multiple fields in to one

eg:

product

customer

amount

these 3 in to a field called as Details how can it be done where in then the details field will have product, customer and amount as field values?

Re: Combine fields

Tue, 27 Nov 2012 15:45:02 GMT

You can use product&customer&amount

the & is a concatenation function. Also you may use Concat

concat([{set_expression}] [ distinct ] [ total [<fld {, fld}>]] expression[, delimiter[, sort_weight]])

Returns the aggregated string concatenation of all values of expression iterated over the chart dimension(s). Each value may be separated by the string found in delimiter. The order of concatenation may be determined by sort-weight. Sort-weight should return a numeric value where the lowest value will render the item to be sorted first.

Examples:

concat( Code, ';' )

concat( FirstName&' '&LastName, ',' )

concat( distinct Code, ';' )

concat( total Name, ';' , Date )

concat( total <Grp> Name, ';' , Date)

Re: Combine fields

Wed, 28 Nov 2012 05:13:59 GMT

let me show you an example,

Product	Customer	order
prod 1	name 1	order1
prod 2	name2	order2
prod 3	name3	order3

then my result column will have

Details

Product

Customer

Order

details will get the product, customer and order which in turn have their values from past table.

Re: Combine fields

jagan — Wed, 28 Nov 2012 05:31:22 GMT

HI,

Try this

LOAD

Product,

Order,

Customer,

Product & Order & Customer AS Details

FROM SourceData;

Hope this what you are expecting.

Regards,

jagan.