topic Year Problem in QlikView

Year Problem

rohitians — Wed, 13 Mar 2013 10:33:36 GMT

How can i introduce in the following code the year factor

Thses to expression is calculating quanttity an rate but it shows total...I want for a particular financial year only....

Quantity:

SUM({$<DocumentType_Code={1}>}PurchaseLine_Qty)

Rate:

if(SUM({$<DocumentType_Code={1}>}PurchaseLine_Qty)>0,AVG(Purchaseline_UnitCost),0)

nirav_bhimani — Wed, 13 Mar 2013 10:50:20 GMT

HI,

Try this Expression.

Current Year Qty:

sum({<Year = {"$(=Max(Year))"},DocumentType_Code={1} >}PurchaseLine_Qty)

Last Year Qty:

Sum({<Year = {"$(=Max(Year)-1)"},Quarter=,Year=, DocumentType_Code={1}}PurchaseLine_Qty)

Regards,

Nirav Bhimani