topic Merging Rows in QlikView

Merging Rows

Mon, 26 Jan 2026 18:19:17 GMT

Hai i had two source fil. One is Excel and another is QVD. I had the values as follows.

Excel:

Category	Value
A-B	6
C	4

QVD:

My Output should be as follows:

Category	Excel Value	QVD Value
A-B	6	7
C	4	5

Need to make QVDs A and B value as A-B value and i need to get the above result. Could anyone answer me pls?

MK_QSL — Wed, 23 Apr 2014 15:52:19 GMT

Use below script

===============

Excel:

Load

Category,

Value as Value1

Inline

[

Category, Value

A-B, 6

C, 4

];

QVD:

Load

If(Category='A','A-B',IF(Category='B','A-B',Category)) as Category,

Value as Value2

Inline

[

Category, Value

A, 2

B, 5

C, 5

];

==========================

Now create a straight Table

Dimension = Category

Expressions

1) SUM(Value1)

2) SUM(Value2)