
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Date picker doesnt recognise date data from load editor using SQL
Hello Qlik Expert!
Sorry if my english is bad.
So as you can see in the subject, right now I want to use the Date Picker extension from Qlik Dashboard Bundle. But when I see in the date field selection, there is no field that I can choose. You can see image below for the proof.
Then I see some another question from Qlik User that have the same problem as me, but all of them load the data not using the SQL like me.
So for the SQL it self, this is the illustration of it
In the auto generated section, this field is already tagged as the Date
And I see some reference that I must change the format from my code as like the calendar picker format
but the result is the same. there is no selection for the date field.
So any suggestions guys ?
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sorry i thought i already deleted this question.
I already solved this problem.
As you can see in my SQL script,
I comment the code
Conver(Date, a.CreatedOn)
However this code is the solution for my problem.
This is the real answer for me. my bad because I didn't check it first.
Btw thanks for your reply.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
try tagging the field as date in your script
Tag "Output Time" with '$date';
If a post helps to resolve your issue, please accept it as a Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sorry i thought i already deleted this question.
I already solved this problem.
As you can see in my SQL script,
I comment the code
Conver(Date, a.CreatedOn)
However this code is the solution for my problem.
This is the real answer for me. my bad because I didn't check it first.
Btw thanks for your reply.
