topic Re: YTD in QlikView

YTD

bharatkishore — Thu, 08 Mar 2018 08:56:41 GMT

HI All,

I am calculating to get ytd logic but some how it is going wrong.

Can you please help me where i am doing wrong.

Attached app for reference.

Thanks,

Bharat

YoussefBelloum — Thu, 08 Mar 2018 09:11:27 GMT

Hi,

are you trying to get the YTD value manually, I mean with the Yearmonth listbox ?

because I don't see a YTD expression in your table

Anonymous — Thu, 08 Mar 2018 09:12:14 GMT

I found this worked for me when I was trying to work out my year to date:

Let vCMonth = Num(Month(Today()));

TRACE *** vCMonth $(vCMonth);

if(Num(month([$(_field)]))<=$(vCMonth),1,0) as [$(_prefix)YearToDateFlag]

Then use the year to date flag in your set analysis