topic Combine 2 Values to create 1 Value in QlikView

Combine 2 Values to create 1 Value

rustyfishbones — Wed, 29 May 2013 10:51:54 GMT

I am currently taking in the following table into Qlikview

I want to add a formula in the Script so that Qlikview Calculates Pallet Config which is Layer Qty 10 and Pallet Qty 120 to give me a result of 10/120

Re: Combine 2 Values to create 1 Value

tresB — Wed, 29 May 2013 11:15:34 GMT

Can you please explain the logic a bit more? may be a bigger size data sample would help. it seems that, you have to use some inter-records function like PEEK or PREVIOUS to achieve that.

Thanks.

Re: Combine 2 Values to create 1 Value

rustyfishbones — Wed, 29 May 2013 11:19:53 GMT

I will always have 2 rows for each product

Each row contains Pallet Qty and Layer Qty in the fields Name and Qty

I want to Join Pallet Qty and Layer Qty as one field called Pallet Config

I don't need more data to explain what I require, hope you can help

Re: Combine 2 Values to create 1 Value

Gysbert_Wassenaar — Wed, 29 May 2013 11:25:59 GMT

Like this for example:

Data:

LOAD * INLINE [

Product, Name, Qty

1, Layer Qty, 10

1, Pallet Qty, 120

2, Layer Qty, 20

2, Pallet Qty, 80

];

join

load Product, concat(Qty,'/') as [Pallet Config]

resident Data

group by Product;

If necessary you can add a sort criterium to the concat function as third parameter.

Re: Combine 2 Values to create 1 Value

Wed, 29 May 2013 12:11:20 GMT

try this

table1:

LOAD * INLINE [

product, name, quantity

1, layer qty, 10

1, pallet qty, 120

2, layer qty, 20

2, pallet qty, 80

];

LOAD product,

min(quantity) & '/' & max(quantity) as [pallet config]

Resident table1

group by product;

In Straight table--

Dimension-- product

name

quantity

Expression-- [pallet config]

then output like this

product	name	quantity	[pallet config]
			-
1	layer qty	10	10/120
1	pallet qty	120	10/120
2	layer qty	20	20/80
2	pallet qty	80	20/80

Re: Combine 2 Values to create 1 Value

rustyfishbones — Wed, 29 May 2013 12:28:03 GMT

Thank you that's what I need