topic Between dates set analysis with variables in QlikView

Between dates set analysis with variables

Thu, 18 Oct 2012 19:07:50 GMT

what is the right syntax for the following:

sum({<Date= {"<=$(=vYesterday))>=$(=vLastWeek)"}> } Sales)

for some reason it doesn't work..

(vYesterday and vLastWeek are variables)

Thu, 18 Oct 2012 19:12:29 GMT

Try this:

sum({<Date= {"<=$(=vYesterday)"}, Date = {">=$(=vLastWeek)"}> } Sales)

MayilVahanan — Thu, 18 Oct 2012 19:27:11 GMT

Try like this

sum({<Date= {'<=$(=vYesterday) >=$(=vLastWeek)'}> } Sales)

Did u check both are in same format?

hope it helps.