I have some problems with a date time value that i am loading in qlik sense. For some reason qlik sense doesn`t recognize it anymore as a date time value. i have loaded the exact same data previously in my other dashboard and qlik sense recognized it as a date time and made a automated calendar of it.
I found a solution for my problem. It was easier than i thought. I don`t think that this is the best solution, because i want it to be automated by Qlik sense. But what i have now works for me.
i just typed this: =year(effectiveDateTime) in the Fx dimension. This only gives back the years of the timestamp. it`s al little more work if you want to have a drill down on month, day etc. but it works. I found this solution with help of this site: