QlikView formula error

[#1]

Hi Guys,

Am facing formula error in QlikView if you see the image below I would give an idea

basically when its come to maths sum(A) - sum(B+C)  and sum(A) - sum(B) - sum(C) are output same value but

in QlikView I get two deference figures. can any one explain me why is this? for your reference I have attached an excel file

Thanks in advance!

Message was edited by: Mafaz Jaufer Please find the QVD attachment...

[#2]

Dear Jagan,

Thank you so much for looking in to my call!!!

I have already attached all the relevant documents you can find it above in my discussion 

[jagan]

HI,

Reload this file and check the issue exists.

Regards,

Jagan.

[#4]

Dear Jagan,

Still am getting two figures. can you please help me to short this out....

[prodanov]

This is correct answer.

[jagan]

HI,

Can you attach the QVDs you are using?

Regards,

Jagan.

[#7]

Thanks for your consideration...

Please find the QVD's in the above discussion. hope you will give me a favourable answer  

[jagan · Accepted solution]

Hi,

Please find attached file for solution.

Regards,

Jagan.

[#9]

wow.. it looks okay. Can you please explain the code below. coz when I run this code my data get empty 

CORE:

LOAD DATE,

     FACTORY,

     BUYER,

     BUDGET,

     ALLOCATION,

     PROJECTION,

     PRODUCT_CATEGORY,

     0 AS ACTUAL_SAH

FROM

[CORE.qvd]

(qvd);

Concatenate(CORE)

LOAD DATE,

     FACTORY,

     BUYER,

     PRODUCT,

     ACTUAL_SAH,

     0 AS BUDGET,

     0 AS ALLOCATION,

     0 AS PROJECTION

FROM

[tbl_LOAD.qvd]

(qvd);

[jagan]

Hi,

I am just concatenating or Union (In SQL) two qvds into one table instead of two tables.

Regards,

Jagan.

[#11]

THANKS A LOT RIGHT SOLUTION ON RIGHT TIME