Discussion board where members can get started with QlikView.
I am having 3 excel files
ProductName, Quantity, OpeningStock
ProductName, Quantity, PrimarySales
ProductName, Quantity, SecondarySales
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.
1. You just need to load 3 excel files
2. Create a straight table with remaining stock dimension.
View attached example.
Hope it helps
I am using Personal Edition, so I can't open qvw you attached. Can you Pls share code.
Also I want to calculate "RemainingStock" at the backend in the script.
open as o
(ooxml, embedded labels);
prim as p
Then i have created a straight table with remaining stock as dimension.
What you wrote in the expression field in your straight table ??
Did you use "Calculated Dimension" in the Dimension Tab ??
=(OpeningStock + PrimarySales) - SecondarySales
and labelled it as RemainingStock..
It worked very fine
You can use expression and calculated dimension both.. Both work fine
Try following code:
(OpeningStock + PrimarySales) - SecondarySales as RemainingStock
DROP TABLE temp;
Hope this helps.
Thanks Supriya & Neharangari. Sorry, I never mentioned that all 3 tables are crosstables. I guess 'Join' don't work in crosstables.