topic Issue in YTD expression in QlikView

Issue in YTD expression

Mon, 23 Jun 2014 06:49:07 GMT

Hi all,

I need to show May YTD in my expression.

so, i gave the following expression

sum

({<Year={$(vYear)},Month={">$(vFirstPeriod)<$(=vMonth)"}>}sales/1000

vYear =Year(Today())

vFirstPeriod = Month(YearStart(Today()))

vMonth=Month(MonthStart(Today())-1)

which is 2014, Jan to May.

kindly correct me where i went wrong.

Thanks in advance,

sheela

Re: Issue in YTD expression

alexandros17 — Mon, 23 Jun 2014 06:52:57 GMT

Use $ expansion even on the last variable (rfemove the =):

sum({<Year={$(vYear)},Month={">$(vFirstPeriod)<$(vMonth)"}>}sales/1000)

Re: Issue in YTD expression

Mon, 23 Jun 2014 07:22:45 GMT

Hi Alessandro, Still i am getttin only 0 in the column.

Re: Issue in YTD expression

mdmukramali — Mon, 23 Jun 2014 07:24:22 GMT

Dear,

Can you share the sample file.

Thanks,

Mukram

Re: Issue in YTD expression

alexandros17 — Mon, 23 Jun 2014 07:26:56 GMT

Could you try the same expression without dividing by 1000?

Re: Issue in YTD expression

jagan — Mon, 23 Jun 2014 07:47:23 GMT

Hi,

Try like this

What is your month format? Is it 1,2,3, or Jan, Feb, Mar? If it is 1,2 3, then try below expression

=sum({<Year={$(vYear)},Month={'<=$(=vMonth)}>}sales/1000)

or if you have a date field then try this expression

=sum({<YearDimensionName={$(vYear)},MonthDimensionName=, DateDimensionName={'<=$(=MonthEnd(Today(), -1))'}>}sales/1000)

Replace YearDimensionName,MonthDimensionName, DateDimensionName with your actual field names.

Hope this helps you.

Regards,

Jagan.

Re: Issue in YTD expression

Mon, 23 Jun 2014 10:39:17 GMT

Thanks fr your repli,

but it dint work

Regards,

Vidhya

Re: Issue in YTD expression

jagan — Tue, 24 Jun 2014 03:50:29 GMT

Hi,

Can you attach sample file and expected output?

Regards,

Jagan.