topic Inputbox to accept date in QlikView

Inputbox to accept date

amars — Fri, 05 Jun 2009 12:27:17 GMT

Hi all,

I have a qlikview file with section access. After opening it I reload the file with only record's with the filter for the user . Now I want to apply a filter for date, It should be like after section access & before reload. It should ask me Input for Start Date & End Date and should load data only for that duration. I can use Input box in Macro but the user may enter wrong value & that can cause trouble. How can I accept input without any problem's. Any ideas on that.

Thanks in advance for your valuable input's

Regards

Amar[:'(]

Inputbox to accept date

Fri, 05 Jun 2009 13:13:57 GMT

Hi,

what do you think about a Calendar Object?

Rainer

Inputbox to accept date

amars — Fri, 05 Jun 2009 16:34:36 GMT

Thank's Rainer.

But How to call a Calender object & accept the value in a variable. If you have any example plese let me know about it.

Regards,

Amar

Inputbox to accept date

Fri, 05 Jun 2009 17:55:37 GMT

Amar,

see the application I attached.

The macro part is not perfect. Maybe one of our more experienced colleagues can help out here.

Rainer

Inputbox to accept date

amars — Fri, 05 Jun 2009 19:02:09 GMT

Thank's Rainer,

But sorry , I know this is some what discouraging but this is not exactly as what I wanted , I want to pop up a calender object or something in which I can enter date (without error) from a macro.

Thanks Again for the kindness.

Regards

Amar

Inputbox to accept date

Anonymous — Fri, 05 Jun 2009 23:41:03 GMT

I'm not sure there is a clean solution. Can you try this logic:
1. In the script, call the Input box. User enters some date.
2. In the script, check if this is a valid date.
3. If yes, go to p. 6.
4. If not, open another input box, probably with some meaningful message for user.
5. Go to p. 2.
6. Continue.
You should also check if ther End Date is later than Start Date.

Inputbox to accept date

amars — Mon, 08 Jun 2009 11:23:22 GMT

Thank's Michael,

I will try this.

Regards

Amar

Inputbox to accept date

rwunderlich — Tue, 09 Jun 2009 06:52:47 GMT

You can use standard InputBox objects with a custom constraint that tests for a valid date.

=NOT IsNull(date(date#($)))

Error message is also supported in the constraint. See attached for an example.

-Rob

Inputbox to accept date

Anonymous — Tue, 09 Jun 2009 08:40:24 GMT

Yes Rob,
I'm also using input boxes for dates, combined with macros that check the vlidity of the input - it must be a date, possibly within some range, and Start date must be earlier than End date. I think your solution is more robust, I'll take a closer look.
As for Amar's question, I think that he wants to enter dates on reload. Not sure now if I got the question right.

Inputbox to accept date

amars — Tue, 09 Jun 2009 17:45:45 GMT

Yes michael ,

I want it that way only. I already have used it in one of my example where in input box I accept date by using

set EnteredFromDate = ActiveDocument.GetVariable("vDate")
FromDt = Inputbox("Please enter From Date in MM/DD/YYYY format","From Date",EnteredReloadFromDt)
If Not IsDate(FromDt) Then
Msgbox "Invalid Date"
FromDt = "01/01/1900"
End If

but I was not able to use goto label in this. If you can tell me that?

Thanks for your valuable inputs

Regards

Amar

Inputbox to accept date

Anonymous — Wed, 10 Jun 2009 00:41:08 GMT

Amar,
There is no GoTo (I wish it were). What I suggested in my earlier post was not a ready solution but a logical algorythm. But QV does have some scrpt control abilities, for example "Do ... loop", which can be used like here:


LET DateCheck = null();
Do until DateCheck='OK'
 EnterStartDate:
 Load
 Input('Enter Start Date as MM/DD/YY', 'Start Date') as Start
 autogenerate 1;
 LET vStartDate = peek('Start');
 //
 if len(trim(date(date#(vStartDate, 'MM/DD/YY'))))>0 then
 LET DateCheck = 'OK';
 else
 LET DateCheck = 'Not a Date';
 end if
 //
loop
DROP TABLE EnterStartDate;
LET DateCheck = null();

Try to run this script and enter different types of data - text, numbers, whatever. It will allow to continue only if you enter a date.
(Notice that there is no need to use macro.)

Inputbox to accept date

Anonymous — Wed, 10 Jun 2009 01:00:43 GMT

The attached example checks the Start and End dates to be valid dates, and if the End date is later than Satrt date.

Inputbox to accept date

rwunderlich — Wed, 10 Jun 2009 09:24:03 GMT

I like your solution Michael. Just for completeness, I extended my alternative InputBox example to handle two dates and test Start < End. The constraint could be extended to test for min/max values as well. Reload will use the dates to generate a range of dates.

I also modifed my test to use the more robust len() check instead of IsNull(). Thanks for reminding me of that!

Your solution is probably more fitting for the original question. but my example might be useful for some of the other questions I've seen about user entered date ranges.

Example attached.

-Rob

Inputbox to accept date

amars — Wed, 10 Jun 2009 11:49:25 GMT

Thank's bot of you Michael, Rob. The example's were of great help.

Regards,

Amar