YTD

[qlikview979]

Hi Experts,

I have source file like this,

ID	NAMES	SAL	YEAR
111	RAJ	10000	10/10/2001
222	RAJA	20000	2/20/2002
333	SRI	30000	11/25/2003
444	NANDU	60000	3/30/2004
555	SAI	70000	5/5/2016

I am tryingto acheive YTD but i am not getting .

Dimension :- Year

Expression:- sum({<YEAR={">=$(=YearStart(=Today()))<=(=Today())"}>}SAL)

[Kushal_Chawda · Accepted solution]

sum({<YEAR={">=$(=YearStart(Today()))<=$(=Today())"}>}SAL)

or

sum({<YEAR={">=$(=YearStart(max(YEAR)))<=$(=max(YEAR))"}>}SAL)

[qlikview979]

Hi Kushal,

Thanks,I got It.

Regards,
Mahesh

[avinashelite]

Try like this

sum({<YEAR={">=$(=YearStart(Today()))<=$(=Today())"}>}SAL)

[Kushal_Chawda]

Not a problem

[qlikview979]

Hi,

Thanks, Avinash

Regards,
Mahesh

[avinashelite]

np problem