Date graphs

[#1]

Hello,  I am a beginner in Qlik sense and I have imported a xls file with a field called [Datum opgelost] with date format 15-02-2015 12:15 (dd-mm-yyyy hh:mm). I have tried to use data load editor to generate my XY graph whereas X is day, week or months and Y is number of registered incidents   What I want is to count the number of registered incidents that were registered on a day, week or months. The service call's are registerd as described above. How do I get a line graph which shows the number of service call's?   Thx in advance.   Nick Overwater

[jonathandienst]

Edit your load script manually to add the following

LOAD ....

     Date(Date#([Datum opgelost], 'dd-MM-yyyy hh:mm')) As [Datum opgelost],

     Month(Date#([Datum opgelost], 'dd-MM-yyyy hh:mm')) As [Maand opgelost],

     Day(Date#([Datum opgelost], 'dd-MM-yyyy hh:mm')) As [Dag opgelost],

     Year(Date#([Datum opgelost], 'dd-MM-yyyy hh:mm')) As [Jaar opgelost],

     Week(Date#([Datum opgelost], 'dd-MM-yyyy hh:mm')) As [Week opgelost],

     ...

Now you can use those calendar fields in your front end.

[#3]

Hello Jonathanm for the quich reply.

I loaded the code  and get the next warning

The following error occurred:

Field names must be unique within table

[#4 · Accepted solution]

I think that here you redefine an existing column with the same name.

...Date(Date#([Datum opgelost], 'dd-MM-yyyy hh:mm')) As [Datum opgelost],...

You can omit the "AS ..."

Regards,

L

[jonathandienst]

Did you remove the line that returned [Datum opgelost] after adding the code I suggested? There can only be one line returning a field name.

[#6]

Hello Louis and Jonathan,

It workedout well omitting the "AS".

Thanks a lot!

Nick