topic Re: Set Analysis Between Dates in QlikView

Set Analysis Between Dates

Anonymous — Fri, 14 Jun 2013 17:52:55 GMT

I'm trying to find the values between two dates using variables. I would like to show everything between vCompareDate and vPriorMonthEnd but this is giving me data outside that date range. Any ideas?

sum({< vo_date_paid = {'>=$(#=vCompareDate - 30)'}, vo_date_paid = {'<=$(#=vPriorMonthEnd)'}>} vo_amt_net)

Re: Set Analysis Between Dates

Fri, 14 Jun 2013 18:05:03 GMT

Try this:

sum({< vo_date_paid = {'>=$(#=(vCompareDate - 30))<=$(#=vPriorMonthEnd)'}>} vo_amt_net)

Re: Set Analysis Between Dates

Anonymous — Fri, 14 Jun 2013 18:06:55 GMT

That worked! Thanks!

Re: Set Analysis Between Dates

Wed, 10 Jul 2013 13:39:11 GMT

Hi Heathero, would you mind telling, in what format do you have your variables?

Re: Set Analysis Between Dates

Anonymous — Wed, 10 Jul 2013 16:41:34 GMT

I was able to get this resolved. Thanks!

Re: Set Analysis Between Dates

Wed, 10 Jul 2013 18:18:24 GMT

I know, is that i might be using what you finally got there. And i want to compare it to my proyect.

Re: Set Analysis Between Dates

Anonymous — Wed, 10 Jul 2013 19:15:44 GMT

Here is how my variable was created.