topic Result in TUBULAR form in QlikView

Result in TUBULAR form

MK_QSL — Tue, 30 Apr 2013 09:57:19 GMT

Hi All,

Need your urgent help !!

We are sales based company keeping all parts in two different quality. i.e. Higher and Lower.

Sales on both quality parts are recorded seperately.

Example ....

I have one table showing all part details...

Part NO (Higher Quality)	Part NO (Lower Quality)
A11HQ	A11LQ
A12HQ	A12LQ
A12HQ	A13LQ

Here A11 is the actual part number having two different qualities. i.e. A11HQ and A11LQ and so on.

Below Sales table showing their sales data. This table contains combined data for Higher and Lower Quality parts.

Part NO	Sales
A11HQ	100
A12HQ	104
A12HQ	39
A11LQ	60
A12LQ	62
A13LQ	64

Need Final Result like below....

Part NO (HQ)	Sales	Part NO (LQ)	Sales
A11HQ	100	A11LQ	60
A12HQ	104	A12LQ	62
A12HQ	39	A13LQ	64

Re: Result in TUBULAR form

MK_QSL — Tue, 30 Apr 2013 16:30:13 GMT

Any reply?

Re: Result in TUBULAR form

Gysbert_Wassenaar — Tue, 30 Apr 2013 17:38:09 GMT

Your AH12HQ part doesn't have one, but two AHxxLQ counterparts. It's impossible to match them without more information to determine which part and sales values are supposed to belong together.

If the second AH12HQ should actually be AH13HQ then you can try this:

SalesMap:

mapping LOAD * INLINE [

Part NO, Sales

A11HQ, 100

A12HQ, 104

A13HQ, 39

A11LQ, 60

A12LQ, 62

A13LQ, 64

];

Result:

LOAD *,

applymap('SalesMap',"Part NO (Higher Quality)") as Sales_HQ,

applymap('SalesMap',"Part NO (Lower Quality)") as Sales_LQ

INLINE [

Part NO (Higher Quality), Part NO (Lower Quality)

A11HQ, A11LQ

A12HQ, A12LQ

A13HQ, A13LQ

];

The inline loads are just examples. You can replace them with load statements to retrieve the data from your data sources.

Re: Result in TUBULAR form

MK_QSL — Wed, 01 May 2013 12:09:01 GMT

Dear Gysbert,

You are absolutely right. There was typing mistke for A13HQ...

It's working..