topic Re: Date Variable Between and To - No Data Returned in QlikView

Date Variable Between and To - No Data Returned

ivandrago — Thu, 11 Dec 2014 12:08:17 GMT

Hi,

I have a sales data model which joins to a date calendar table. I have a list box for the fields from the calendar Day, Month, Year so the users can select the dates they wish to see. I also have a calendar object that looks at two variables vStartDate and vEndDate, when the user clicks on the macro button next to these objects it will execute the following Actions

='=Date >= vStartDate and Date <= vEndDate'

The problem I am facing is that there are some invoice dates where there hasn't been any invoices done on that day i.e. a weekend but if the users entered these dates then Execute the results, they are non the wiser it is only when looking at the current seletions that the filter for the action is not met. Any ideas on how to warn users that their conditions are not valid?

Thanks

Re: Date Variable Between and To - No Data Returned

Michiel_QV_Fan — Thu, 11 Dec 2014 12:23:04 GMT

Add 2 listboxes with the possible dates from the calendar and abandon the macro? Then the user will only be able to select enddates that are valid for the startdate.

Re: Date Variable Between and To - No Data Returned

ivandrago — Thu, 11 Dec 2014 12:41:34 GMT

Hi,

The calendar is used for another data model as well where the data model is concatenate under the sales model, I have hard coded field called Ty[pe to determine the difference between the two, so the date could be valid for the other model.

Thanks

Re: Date Variable Between and To - No Data Returned

ivandrago — Thu, 11 Dec 2014 13:06:41 GMT

How would do the possible dates anyway? Do you have a example?

Re: Date Variable Between and To - No Data Returned

Michiel_QV_Fan — Thu, 11 Dec 2014 13:40:40 GMT

The dates from the calendar are linked to your invoiced date's somehow?

Or is the calendar not linked to the datamodel? Which can be very usefull.

Can you post a screen print form the table viewer? (ctrl+t)

Re: Date Variable Between and To - No Data Returned

ivandrago — Mon, 15 Dec 2014 17:58:33 GMT

Please find attached the Document I have the issue with.

Re: Date Variable Between and To - No Data Returned

kamal_sanguri — Mon, 15 Dec 2014 18:30:11 GMT

Please look at the attachment, I have made some changes and it should work the way you want.

Thanks,

Kamal

Re: Date Variable Between and To - No Data Returned

ivandrago — Mon, 15 Dec 2014 20:55:21 GMT

Thanks for this Kamal.

Is there anyway of alerting the users to say that the date they have entered does not appearing in the current selections because there is no data for this?

Re: Date Variable Between and To - No Data Returned

kamal_sanguri — Mon, 15 Dec 2014 21:03:54 GMT

Check this out.

Thanks,

Kamal

Re: Date Variable Between and To - No Data Returned

kamal_sanguri — Mon, 15 Dec 2014 21:56:01 GMT

Hi Ivan,

If helped.. please mark this question as answered.. thanks

Kamal

Re: Date Variable Between and To - No Data Returned

ivandrago — Mon, 15 Dec 2014 22:02:17 GMT

Hi,

How do I make it only appear once the user presses the the Enter button?

Thanks

Re: Date Variable Between and To - No Data Returned

kamal_sanguri — Tue, 16 Dec 2014 13:06:12 GMT

Please check this and let me know..

Thanks,

Kamal