How to add this in script level?

Thu, 10 Jan 2013 04:53:04 GMT

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

Re: How to add this in script level?

jaspal_icon — Thu, 10 Jan 2013 05:10:36 GMT

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.

topic How to add this in script level? in QlikView

How to add this in script level?

Re: How to add this in script level?