Set Analysis Date Variable

[Anonymous]

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)

[CELAMBARASAN]

Hi,

try with this

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

[Anonymous]

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.

[Anonymous]

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.

[#5]

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

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

[Anonymous]

That worked! Thanks!

[Anonymous]

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

[#8 · Accepted solution]

Just add <= before de dollar sign expansion:

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

[Anonymous]

That worked! Thanks!