Problem between two dates in set analysis

[Anonymous]

Hi all,

I have a small problem to sum up with two dates.

This one works

Sum({<FILTER_JOUR_ID = {"$(=$(vNdebut))"}, FILTER_JOUR_ID = {"$(=$(vNfin))"}>} CA_TTC_CONSO)

This one is not working

Sum({<FILTER_JOUR_ID = {"$(>=$(vNdebut))"}, FILTER_JOUR_ID = {"$(<$(vNfin)+1)"}>} CA_TTC_CONSO)

I want to sum for the date range, can any one hint me the mistake i am doing.

It is not showing any error in QLIKVIEW and result set is zero.

I checked the date formats, it is the same. dont know what is wrong.  the greater than and lesser than sign creates problem.

Your help will be appreciated.

Thanks in advance

Djega

[sunny_talwar]

Why not like this:

Sum({<FILTER_JOUR_ID = {">=$(=vNdebut)<$(=vNfin+1)"}>} CA_TTC_CONSO)

or

Sum({<FILTER_JOUR_ID = {">=$(=$(vNdebut))<$(=$(vNfin)+1)"}>} CA_TTC_CONSO)

[Anonymous]

I tried both, they did not work;

I did a text box expression, i displayed the variables vNdebut and vNfin - it displays the numerical format correctly.

When i add one to it, it returns null value;

=$(vNfin+1)

I changed the format in the load scripit removing the date format date# into SQL DATE format still i have the problem

[agomes1971]

Hi,

Or

like

This:

Sum({<FILTER_JOUR_ID = {">$(vNdebut) <$(=vNfin)"} >}CA_TTC_CONSO)

HTH

André Gomes