topic Re: About YTD in QlikView

About YTD

sarfaraz_sheikh — Mon, 05 Jan 2015 08:29:53 GMT

Dear All,

I am trying to find the YTD in my application but when i write below expression for YTD ...I am getting nothing in my chart...getting 0 values everytime

Expression is as follows....

Sum( {< Date_Num={" >= $(=Num(YearStart(Max(Date_Num)))) <= $(=Today()-1) "} >} SALARY)

=Sum( {< START_DATE={" >= $(=Date(YearStart(Max(START_DATE))),'DD-MM-YYYY') <= $(=Date(Today()-1,'DD-MM-YYYY')) "} >} SALARY)

attached my QVW also for your reference.....

Regards

Sarfaraz

Re: About YTD

tresB — Mon, 05 Jan 2015 08:37:27 GMT

Try like:

=Sum({<Date_Num={">=$(=Num(YearStart(Max(Date_Num)))) <=$(=(Max(Date_Num)))"} > } SALARY)

Re: About YTD

jonathandienst — Mon, 05 Jan 2015 08:42:36 GMT

=Sum({<Date_Num={">=$(=Num(Max(YearStart(Date_Num)))) <=$(=Num(Today()))"}>} SALARY)

=Sum({<Date_Num={">=$(=Num(YearStart(Max(Date_Num)))) <=$(=Today()-1)"}>} SALARY)

You have embedded spaces into the search expression which is causing a problem. The above two expressions work

HTH

Jonathan

Re: About YTD

djsampat — Mon, 05 Jan 2015 08:58:05 GMT

Use the following:-

=Sum({<START_DATE={">= $(=Date(YearStart(Max(START_DATE))),'DD-MM-YYYY')<=$(=Date(Today()-1,'DD-MM-YYYY'))"}>}SALARY)

Your syntax was correct, but had spaces before and after a few fields, thus showing 0.

If this helped you, please mark as Helpful. If it solves your issue, please mark as Answer

Regards

Dhruv

Re: About YTD

alkesh_sharma — Mon, 05 Jan 2015 09:14:29 GMT

Variables:

vStartdate: =Floor(YearStart(Max(Date_Num))

vToday =Floor((Today)-1)

Expression:

Sum( {< Date_Num={" >= $(=vStartdate) <= $(=vToday "} >} SALARY)

Re: About YTD

sarfaraz_sheikh — Mon, 05 Jan 2015 10:07:29 GMT

Dear Jonathan/Tresesco

Thanks for your reply !!!! now it is working as expected ...........

Regards

Sarfaraz