Urgent Help

[gaurav2017]

Hi there,

I am having 3 excel files

having fields:

ProductName, Quantity, OpeningStock

ProductName, Quantity, PrimarySales

ProductName, Quantity, SecondarySales

resp.

I have to load these 3 files in qlikview & then calculate a new field called "RemainingStock",

which is a calculated field.

RemainingStock = (OpeningStock + PrimarySales) - SecondarySales

How can it be done.

Regards,

Gaurav Malhotra

[jagannalla]

According to logic it should work. What is the wrong? What is the size of your data? If possible attach your script code or file or along with data.

[gaurav2017]

Thanks Jagan, It's done with the reload

but unsurprisingly data is not as expected.

Take a look at my code now attached below.

[jagannalla]

Ok. What is your data expection?

Can you reduce your data and develop a sample application. Send your sample application along with data file. And, also let me know what is the output you need from your sample data.

[gaurav2017]

I hope it helps.

These are my expectations.

Output:

I should be able to see the remainig stock because it is most important kPI at this time.

[jagannalla]

If that is in the case, why can't you write your 3rd expression as (OpeningStock + PrimarySales) - SecondarySales in straight table itself.

[gaurav2017]

Dear,

I had done it & showed to my boss but I want to explore more. It was done before i posted it on community.

[jagannalla]

Why can't you attach sample file? From my case i tried with sample data it is working perfectly. If you attach sample it helps me and other to solve your problem easily.

[gaurav2017]

My dear, all sample files needed are attached within the discussion (Look at those Excel files).

[gaurav2017]

It takes 05 min & 12 sec to reload whole data. It pisses me off.

[gaurav2017]

It was done. Thanks to all for help.:)