topic Re: Set Analysis Date Variable in QlikView

Set Analysis Date Variable

Anonymous — Wed, 12 Jun 2013 23:17:54 GMT

I'm trying to compare vo_date_due to vCompareDate. vCompareDate is a variable that is already in date format. vo_date_due is in Qlikview date format. There is a red line under the second bracket {. Any Ideas?

sum({< date(vo_date_due) = {'$(vCompareDate)'}>} vo_amt_net)

Re: Set Analysis Date Variable

CELAMBARASAN — Thu, 13 Jun 2013 00:44:46 GMT

Hi,

try with this

sum({< vo_date_due ={'$(vCompareDate)'}>} vo_amt_net)

Re: Set Analysis Date Variable

Anonymous — Thu, 13 Jun 2013 16:08:44 GMT

I have tried this but get 0 results. I believe it is because vo_date_due is in number format and vCompareDate is in date format.

Re: Set Analysis Date Variable

Anonymous — Thu, 13 Jun 2013 16:09:27 GMT

I have tried this but get 0 results. I believe it is because vo_date_due is in number format and vCompareDate is in date format.

Re: Set Analysis Date Variable

Thu, 13 Jun 2013 17:39:54 GMT

You can use the # sign to force the variable to be evaluated as a number:

sum({< vo_date_due ={'$(#=vCompareDate)'}>} vo_amt_net)

Re: Set Analysis Date Variable

Anonymous — Thu, 13 Jun 2013 17:43:38 GMT

That worked! Thanks!

Re: Set Analysis Date Variable

Anonymous — Thu, 13 Jun 2013 17:56:11 GMT

Now what is the syntax to change this to <= instead of just =?

Re: Set Analysis Date Variable

Thu, 13 Jun 2013 18:03:52 GMT

Just add <= before de dollar sign expansion:

sum({< vo_date_due ={'<=$(#=vCompareDate)'}>} vo_amt_net)

Re: Set Analysis Date Variable

Anonymous — Thu, 13 Jun 2013 20:37:03 GMT

That worked! Thanks!