Problem with calculation on chart

Wed, 31 Mar 2010 10:52:08 GMT

This is what we did.

There is no current link between the Item and the cost.

In the main document for the ILE quantity we split them out.

ItemLedgerEntry:

LOAD NAVcoile,

EntryID,

ItemIDile,

Key_ItemID,

Key_Cost,

[Posting Date] as Date,

[Posting Date],

[Entry Type],

LocCode,

Key_LocCode,

Quantity,

[Remaining Quantity],

if((Now()-[Posting Date])<=180,([Remaining Quantity])) AS Current_QTY,

if((Now()-[Posting Date])>180,([Remaining Quantity])) AS Aged_QTY,

Open,

[Global Dimension 1 Code],

[Global Dimension 2 Code],

NAVCoSO

FROM

[QVD\ILE.qvd]

(qvd);

We then did the calculation in the cart. =[Current Value LCY]/[Current Stock Qty]*SUM([Current_QTY])

This works fine for that chart.

If we then want to just do a staked bar chart with CO as the bottom axis the original calculation doesn't work because it is calculated at the country level and not the item level.

How would you recommend we do this?

Thanks.

Problem with calculation on chart

Mon, 05 Apr 2010 16:12:20 GMT

Any ideas?

topic Problem with calculation on chart in QlikView

Problem with calculation on chart

Problem with calculation on chart