topic Want YTD on selected date in QlikView

Want YTD on selected date

Fri, 23 Sep 2011 07:29:51 GMT

Hello,

i want YTD to be calculated on Selected date by user.

for example if user select date 15 feb 2009

user should get sales of from 1 jan 2009 to 15 feb 2009

how to do it?

thanks

Harlin

Want YTD on selected date

SunilChauhan — Fri, 23 Sep 2011 07:38:36 GMT

hope this help u

sum({<MonthYear={"=$(Max(MonthYear))"}<}Amount)

Want YTD on selected date

its_anandrjs — Fri, 23 Sep 2011 07:40:17 GMT

Hi,

Use YearStart( DateField )

Rgds

Anand

Re: Want YTD on selected date

its_anandrjs — Fri, 23 Sep 2011 07:48:43 GMT

Hi,

Use some thing like

=If ( Date >= Yearstart(Today()) and Date <= vTest , Date )

vTest = getfieldselections( Date )

Ex:-

vTest = 15 feb 2009

HTH

Rgds

Anand

Want YTD on selected date

Fri, 23 Sep 2011 09:25:47 GMT

Any correct answer in terms of Set analysis??

thanks

Harlin

Want YTD on selected date

SunilChauhan — Fri, 23 Sep 2011 09:32:29 GMT

sum({<MonthYear={"=$(Max(MonthYear))"},{Date={"<=$(=Max(date))"}}<}Amount)

what about this sardar ji

Want YTD on selected date

Fri, 23 Sep 2011 10:15:01 GMT

in your statement why are u using < in the last??

{Date={"<=$(=Max(date))"}}<}

thanks

harlin

Want YTD on selected date

Fri, 23 Sep 2011 10:28:39 GMT

No all above not working.

Any working example??

thanks

Harlin

Want YTD on selected date

Fri, 23 Sep 2011 10:50:36 GMT

Hi Harleen,

be careful if the date is numeric or formatted like dd/mm/yyyy.

This could be the problem.

Stefano.

Re: Want YTD on selected date

Fri, 23 Sep 2011 10:55:35 GMT

Look at this

I hope this helps u

Stefano

Re: Want YTD on selected date

Fri, 23 Sep 2011 11:06:39 GMT

See that there is not control of the year...

Stefano

Want YTD on selected date

Fri, 23 Sep 2011 11:32:32 GMT

Hello

finally this worked

=Sum({$<Year = {$(=max(Year))}, Month={"<=$(=max({<Year={$(=max(Year))}>} Month))"},OrderDay={"<=$(=max(OrderDay))"}>} Value)

thanks Stefano for the response

my date is formated in M/D/YYY format.

thanks

Harleen Singh