Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have a QVD file that has client proposals data. Various versions are created based on client feedback. My aim is to find out the discount given starting from base proposal. The data in QVD files is as follows:
QVD1
"Estimate" "Estimate Copied From" "Price"
X - 1000
Y X 900
Z Y 800
Z11 Z 750
Note: No of iterations is not fixed.
QVD2
Sales Order Estimate
4040 Z11
I want report o/p as follows:
Sales Order Discount Given
4040 (1000-750) = 250
Any idea how I can achieve this?
Regards
Anu
Hi Anu,
This looks like the Hierarchy feature will work, something like ...
//Hierarchy (NodeID, ParentID, NodeName, [ParentName], [PathSource], [PathName], [PathDelimiter], [Depth])
FinalTable:
Hierarchy (Estimate, Estimate_Copied_from, Price,,,,,'Level') LOAD Distinct Estimate, Estimate_Copied_from, Price
Resident QVD1;
DROP Tables QVD1;
This generates multiple fields Price1, Price2, Price3 etc to the required depth, with Price1 the top of the hierarchy. Therefore your Chart expression just needs to be Price1 - Price.
flipside
Hi Anu,
Can you please explain little more. Here you are using X value - Z11 value for Z11. Any specific reason ??
Hi Anu,
This looks like the Hierarchy feature will work, something like ...
//Hierarchy (NodeID, ParentID, NodeName, [ParentName], [PathSource], [PathName], [PathDelimiter], [Depth])
FinalTable:
Hierarchy (Estimate, Estimate_Copied_from, Price,,,,,'Level') LOAD Distinct Estimate, Estimate_Copied_from, Price
Resident QVD1;
DROP Tables QVD1;
This generates multiple fields Price1, Price2, Price3 etc to the required depth, with Price1 the top of the hierarchy. Therefore your Chart expression just needs to be Price1 - Price.
flipside
Bingo!!! Correct Answer!!
Thanks a ton...