topic Another date question in QlikView

Another date question

Mon, 20 Jul 2009 16:22:31 GMT

Hi All,

This is my first question.

Our software package stores data in SQL dates as 1090720

Now if I bring in the date like this it works fine and gives me 2009/07/20


makedate( '20'&mid("EV200_MI_DATE",2,2), mid("EV200_MI_DATE",4,2), mid("EV200_MI_DATE",6,2) ) as EV200_MI_DATE,
[\code]

My problem is I cannot use this date in an input box to select a from and a to date.

Any help?

Thanks

Pieter
 </body>

Another date question

Mon, 20 Jul 2009 16:27:36 GMT

fast solution, you can use mapping table between two types of dates in sql and fetch both of then to sql and use DD and MM and YYYY for input box

Another date question

Mon, 20 Jul 2009 17:13:57 GMT

Thanks for the quick reply. I'm off to learn mapping quickly. Did I mention I just started to learn Qlikview?

Regards

Pieter

Another date question

johnw — Tue, 21 Jul 2009 01:21:17 GMT

You can build the date more simply like this:

date#(right(EV200_MI_DATE,6),'YYMMDD') as EV200_MI_DATE

I don't generally like having the users enter a from and to date. Typically, they want something more basic, such as being able to select a year, or a quarter, or a few months, that kind of thing. So I give them those fields and let them select what they want.

If the date ranges don't tend to follow nice boundaries like that, you can also select a date range using a multi-value slider. I have a few of those sprinkled through my applications. Finally, yes, you can use an input box with variables for the from and to date, but you'll need to use a macro to actually select that date range (actions in version 9?), which I don't tend to think of as "the QlikView way". I don't think I have any applications that use that approach.