topic Re: Number between dates not showing in QlikView

Number between dates not showing

jvitantonio — Mon, 03 Sep 2012 08:21:08 GMT

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.

Re: Number between dates not showing

jvitantonio — Mon, 03 Sep 2012 12:25:13 GMT

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

Re: Number between dates not showing

chematos — Mon, 03 Sep 2012 17:24:31 GMT

I had something like this before

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

Regards

Re: Number between dates not showing

whiteline — Tue, 04 Sep 2012 05:04:18 GMT

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

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

Re: Number between dates not showing

jvitantonio — Tue, 04 Sep 2012 07:26:05 GMT

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...

Re: Number between dates not showing

whiteline — Tue, 04 Sep 2012 07:38:54 GMT

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.

Re: Number between dates not showing

jvitantonio — Tue, 04 Sep 2012 08:01:00 GMT

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