topic Re: Create new field with multipel fields as input in QlikView

Create new field with multipel fields as input

Wed, 14 Nov 2012 11:59:17 GMT

I want to create a new field with input from multipel other fields as shown below.

timestamp1	timestamp2	timestamp3	timestamp4
a	b
a
a	b	c	d
a	b	c

Timestamp1-4 are always filled in the order a, b, c to d (timestamp2 can not have a value without a value in timestamp1)

Now I want to create a new field "result" to show the highest timestamp value.

example

a and b -> b

a, b and c -> c

Result
b
a
d
c

Thank you in advance!

Best regards

Malte

Re: Create new field with multipel fields as input

Wed, 14 Nov 2012 12:15:55 GMT

Hi,

You could add a statement like this in the script:

TableName:

Load *,

if(Time4>Time3 and Time4>Time2 and Time4>Time1 ,Time4),

if(Time3>Time4 and Time3>Time2 and Time3>Time1 ,Time3),if(Time1>Time3 and Time1>Time2 and Time1>Time4 ,Time1) as MaxTime

From SourceFile;

Hope that helps.

-Khaled

Re: Create new field with multipel fields as input

Wed, 14 Nov 2012 13:04:10 GMT

You can also use the concat function:

Load Department, concat(Name,';') as NameList from abc.csv group by Department;

Kind Regards,

Dion

Re: Create new field with multipel fields as input

Gysbert_Wassenaar — Wed, 14 Nov 2012 13:06:59 GMT

try: if(timestamp4,timestamp4,if(timestamp3,timestamp3,if(timestamp2,timestamp2,timestamp1)))

Re: Create new field with multipel fields as input

Wed, 14 Nov 2012 13:29:54 GMT

Brilliant!

Re: Create new field with multipel fields as input

Wed, 14 Nov 2012 14:13:14 GMT

Brilliant!