topic Scripting for price comparison in QlikView

Scripting for price comparison

Tue, 24 Jan 2012 11:18:44 GMT

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

Scripting for price comparison

vijay_iitkgp — Tue, 24 Jan 2012 11:36:21 GMT

Hi Anu,

Can you please explain little more. Here you are using X value - Z11 value for Z11. Any specific reason ??

Scripting for price comparison

flipside — Tue, 24 Jan 2012 13:31:17 GMT

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

Scripting for price comparison

Tue, 24 Jan 2012 19:08:16 GMT

Bingo!!! Correct Answer!!

Thanks a ton...