topic Re: Problem between two dates in set analysis in QlikView

Problem between two dates in set analysis

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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 — Mon, 29 Aug 2016 12:53:55 GMT

Why not like this:

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

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

Anonymous — Mon, 29 Aug 2016 13:41:57 GMT

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 — Mon, 29 Aug 2016 14:17:31 GMT

Hi,

This:

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

HTH

André Gomes