Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ivandrago
Creator II
Creator II

Date Variable Between and To - No Data Returned

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

1 Solution

Accepted Solutions
kamal_sanguri
Specialist
Specialist

Please check this and let me know..

Thanks,

Kamal

View solution in original post

11 Replies
Michiel_QV_Fan
Specialist
Specialist

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.

ivandrago
Creator II
Creator II
Author

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

ivandrago
Creator II
Creator II
Author

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

Michiel_QV_Fan
Specialist
Specialist

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)

ivandrago
Creator II
Creator II
Author

Please find attached the Document I have the issue with.

kamal_sanguri
Specialist
Specialist

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

Thanks,

Kamal

ivandrago
Creator II
Creator II
Author

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?

kamal_sanguri
Specialist
Specialist

Check this out.

Thanks,

Kamal

kamal_sanguri
Specialist
Specialist

Hi Ivan,

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

Kamal