Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Problem between two dates in set analysis

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

3 Replies
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
Not applicable
Author

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
Specialist II
Specialist II

Hi,

Or

like

This:

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

HTH

André Gomes