How to add this in script level?

[#1]

Hi all

I have a 2 excel sheets with same field names Month wise data

Excel 1:

flag,sale

a,100

Excel 2:

flag,sale

b,200

in qlikview i fetched these 2 excels & my output is like this

flag,sale

a,100

b,200

Now My question is:

i want output like this

flag,sale

a,100

b,200

difference,100(difference means 200-100=100)

How can we do in one list box can we bring difference as a dimenionand sale 100 also bring dimension

Please Help?

Regards,

Ananth

[jaspal_icon]

Hi ananth, Concatenate both table with some Key Field to recognise table a and b and then in List box use expression if(type='a', Sale)-if(type='b',Sale)

I got short time to reply, there could me some more efficient way.