topic Re: set analysis? in QlikView

set analysis?

Anonymous — Mon, 30 Mar 2015 14:46:52 GMT

=sum({<date={'>=$(=YearStart(today()))<=$(=today())'}>}[budget amount])

what is the wrong in expression ?

i am getting 0 always result here ?

Re: set analysis?

robert_mika — Mon, 30 Mar 2015 14:51:53 GMT

Could you attached your qvw?

Re: set analysis?

hic — Mon, 30 Mar 2015 14:55:07 GMT

It could be that your YearStart() and Today() return strings, so that you need to enclose then in single quotes. Further, you need to enclose the search string in double quotes. Hence, try

=sum({<date={">='$(=YearStart(today()))'<='$(=today())'"}>}[budget amount])

HIC

Re: set analysis?

sunny_talwar — Mon, 30 Mar 2015 14:58:13 GMT

May be try this:

Create a variable

vRange = '>=' & Date(YearStart(Today()), 'yourDateFormat') & '<=' & Date(Today(), 'yourDateFormat') (try saving the variable without the = sign, if it doesn't work then try it with the = sign)

=Sum({<date={'$(vRange)'}>}[budget amount])

Let me know if that solved your problem

Best,

Sunny

Re: set analysis?

Anonymous — Mon, 30 Mar 2015 15:07:30 GMT

PFA

PLS CORRECT ME

Re: set analysis?

sunny_talwar — Mon, 30 Mar 2015 15:17:24 GMT

Budget amount for 2015 is 0

Re: set analysis?

buzzy996 — Mon, 30 Mar 2015 15:19:11 GMT

u don't have proper data to show results according to ur expression

Re: set analysis?

Anonymous — Mon, 30 Mar 2015 15:19:43 GMT

you need to format year and month (they are number and string) to date format using makedate(year,month)

Re: set analysis?

Anonymous — Mon, 30 Mar 2015 15:24:58 GMT

Thanks a lot

Re: set analysis?

sunny_talwar — Mon, 30 Mar 2015 15:27:39 GMT

Thanks? Did that solve your problem? I thought that was your sample data and you will update the sample data to test the expression.

If missing data was the issue, then I guess we know why your expression wasn't working

Best,

Sunny