Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.