Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Why isnt Qlik Sense 2.2 handling my dates in the new way?

I am trying to get my data to get the date filters into the data without having to create the master calendar function. The new update to Qlik 2.2.3 says the dates should be identified automatically and the new function should be automatically in place. But this is not working for my data. I have tried uploading both CSV files as well as Excel files but neither worked. Any thoughts or extra steps that are need to make this new function work?

Tags (1)
1 Solution

Accepted Solutions
rva_heldendaten
Contributor III

Re: Why isnt Qlik Sense 2.2 handling my dates in the new way?

When Qlik Sense detects your Date-Field correctly, it autogenerates the DECLARE statement.

See screenshot. If you add this manually to your script editor, I would expect it to work!

Qlik Sense Desktop_2016-03-03_20-20-48.jpg

8 Replies
Not applicable

Re: Why isnt Qlik Sense 2.2 handling my dates in the new way?

Does the Data Manager recognise your fields as dates? (there should be a small Calendar icon below the fieldname)

Re: Why isnt Qlik Sense 2.2 handling my dates in the new way?

Does the csv file contain dates with the same date format as the default you set in your Qlik Sense app?


talk is cheap, supply exceeds demand
rva_heldendaten
Contributor III

Re: Why isnt Qlik Sense 2.2 handling my dates in the new way?

For me it only works if I go through the "Data Manager" to add autogenerated script.

For manually coding in the Script Editor, it seems the Date-Fields are not automatically generated. You need to define the DECLARE-Statement in the script yourself.

Not applicable

Re: Why isnt Qlik Sense 2.2 handling my dates in the new way?

The Data Manager doesn't seem to recognize the dates. I do not have a calendar icon in my data below the field name.

Not applicable

Re: Why isnt Qlik Sense 2.2 handling my dates in the new way?

Yes the CSV files has the dates in a standard form MM/DD/YYYY. 

Not applicable

Re: Why isnt Qlik Sense 2.2 handling my dates in the new way?

I am thinking this might be getting closer to the issue. I have been able to get it to work with the data if I create a new app and add the data. But I can not get it to work in the data that has been modified in an old app that I had created before 2.2.

But I am not sure how to define the "declare" statement that you mentioned. So I will try to follow that path to see where it leads me.

rva_heldendaten
Contributor III

Re: Why isnt Qlik Sense 2.2 handling my dates in the new way?

When Qlik Sense detects your Date-Field correctly, it autogenerates the DECLARE statement.

See screenshot. If you add this manually to your script editor, I would expect it to work!

Qlik Sense Desktop_2016-03-03_20-20-48.jpg

Not applicable

Re: Why isnt Qlik Sense 2.2 handling my dates in the new way?

Thanks  rvfigueroa, it looks like all I needed to add was the bottom section. Not the Date() piece.