Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Luminary
Luminary

Number between dates not showing

Hi,

I have an application with actuals and budget. I have a table where I store my budget for different dates. The thing is the comparison for the dates is not working as the table for budget is showing always 0. Please check the application for further details. I appreciate your time and help.

6 Replies
Luminary
Luminary

Re: Number between dates not showing

Anyone please? Any input will be appreciate it...

chematos
Valued Contributor II

Re: Number between dates not showing

I had something like this before

sum({<REFERENCES.DATE_FROM={'>=$(vMinFullDate)<=$(vMaxFullDate)'} >} REFERENCES.VALUE)

Regards

whiteline
Honored Contributor II

Re: Number between dates not showing

He has two fields REFERENCES.DATE_FROM and REFERENCES.DATE_TO.

And it seems that REFERENCES.DATE_TO selection is not working.

Luminary
Luminary

Re: Number between dates not showing

That is correct whiteline. Also, when I remove the hour from the date it works but when I have the long date format 'DD/MM/YYYY hh:mm:ss' it doesn't...

whiteline
Honored Contributor II

Re: Number between dates not showing

Moreover, I tried to compere the values (with hours) and it gives TRUE in a text box, while set analysis returns an empty set with the same statement.

Luminary
Luminary

Re: Number between dates not showing

I think I know why... I'm comparing 4 dates that can be offset (can be or not included in the second dates). And in set analisys we are doing D1>= D2 "AND" D3<=D4. This condition is not always true. I change the data. Before I could have a range (1 record could be valid for Jan and Feb). Now I place 1 record for Jan and 1 for Feb so I don't have problem comparing the dates. It's a bit hard to explain