topic QTD Expression Issue in QlikView

QTD Expression Issue

vanderson009 — Thu, 12 Dec 2013 10:28:21 GMT

Hi Community,

I have build set expression for

CY QTD as

= sum({<SalesDate={">=$(=QuarterStart(max(SalesDate)))

<=$(=max(SalesDate))"},

Sales_Year=,

Sales_Month=,

Sales_Quarter=,

Sales_Day=>}Sales)

LY QTD as

=SUM({<SalesDate={">=$(=monthstart(max(Sales_QuarterStart),-12))
<=$(=addmonths(max(Sales_Date),-12))"},

Sales_Month=,

Sales_Week=,

Sales_Day=>} Sales)

Without any selection On Year and Quarter Both expression gives Sales Value.

But On Selection On Year and Quarter LY QTD not reflecting any Sales Value....

Is thr any wrong logic with LY QTD????

Thanks and Regards,

Villeyy.

Re: QTD Expression Issue

perumal_41 — Thu, 12 Dec 2013 11:10:36 GMT

Hi Villyee

Use this Expression

= sum({<SalesDate={">=$(=QuarterStart(max(SalesDate),-12))

<=$(=max(SalesDate),-12)"},

Sales_Year=,

Sales_Month=,

Sales_Quarter=,

Sales_Day=>}Sales)