Logic Help

[abhaysingh]

HI all,

i want one analysis Current year Vs Previous Year but in this i want suppose CY i having 4 month as Per Fiscal Year Apr,May,Jun,July 2015,

Now i want PY should contain Same Four month which as Current Year, Not Full year..

How i can do this??

please suggest

[qlikviewwizard]

jagan mohan <span class="icon-status-icon icon-mvp" title="Mvp"></span> <span class="icon-status-icon icon-partner" title="Partner"></span> wrote:

Hi,

Try this expressions

Current Year:

Sum({<Year=, FiscalYear=, Month=, Quarter=, DateFieldName={'>=$(=YearStart(Today(), 0, 4))<=$(=Today())'}>} Sales)

Current Year:

Sum({<Year=, FiscalYear=, Month=, Quarter=, DateFieldName={'>=$(=YearStart(Today(), -1, 4))<=$(=YearEnd(Today(), -1, 4))'}>} Sales)

Replace Year, FiscalYear, Month, Quarter and DateFieldName with your actual field names.

Hope this helps you.

Regards,

Jagan.

Hi jagan

Is this Previous Year?

Current Year:

Sum({<Year=, FiscalYear=, Month=, Quarter=, DateFieldName={'>=$(=YearStart(Today(), -1, 4))<=$(=YearEnd(Today(), -1, 4))'}>} Sales)

?

[jagan]

Hi,

It is for Previous Year

Sum({<Year=, FiscalYear=, Month=, Quarter=, DateFieldName={'>=$(=YearStart(Today(), -1, 4))<=$(=YearEnd(Today(), -1, 4))'}>} Sales)

Regards,

Jagan.