QlikView App Dev

[#1]

Hi,

My job is to obtain sum of Ordered_Quantity for "Present Year-to-date and Previous Year-To-Date" for one selection using straight chart, by taking Sold_to_org_id as dimension and I have used expressions to obtain Present Year-To-Date and Previous Year-To_Date.

I have created Year, Month and Day using Inline Load and used these values for selection.

I have succeeded in getting the output for Present Year-To-Date by using expression,

Sum({<Year=, Month=, Day=, DateNum={">=$(=Num(YearStart(Max(DateNum))))<=$(=Max(DateNum))"}>} OE_ORDER_LINES_ALL.ORDERED_QUANTITY)

Where Datenum = (Floor(orderdate))

I am having issue with Previous Year_To-Date. I have tried all, the expressions I Knew and got from blogs, but still it is displaying zero's.

Can anyone help me in obtaining the sum of Ordered_Quantity for  Present Year_To-Date as well as Previous Year_To-Date using one selection of Year,  Month and Date.

Thanks & Regards,

Varun.

[#2]

Hi,

Try this expression:

(Sum({$<DateNum={"<=$(=Max(DateNum))"}, Year={"$(=Max(Year))"}, Year=, Month=, Day=>}[OE_ORDER_LINES_ALL.ORDERED_QUANTITY]) /

Sum({$<DateNum={"<=$(=Max(DateNum)-12)"},

Year={"$(=Max(Year)-1)"},Year=,Month=,Day=>}[OE_ORDER_LINES_ALL.ORDERED_QUANTITY]))-1