Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have an issue related to date format. Appreciate if you can give some help.
Per screen shot #1:
> This is my data source, from column C: the dates are showing as e.g. 21/10/2021 i.e. 21 Oct 2021
Per screen shot #2:
> You may see how I load the data to Qlik, and I have created 2 columns “Statement Date” and “Statement Date 2”
Per screen shot #3:
> I have created 2 bar charts, basically they are the same except one is with “Statement Date” and the other with “Statement Date 2”
> All looked fine until…
Per screen shot #4:
> I clicked on the first bar with “Jan 2021” on the “bar chart in Statement Date 2”
> I saw the breakdown on the “ bar chart in Statement Date” but it’s showing as “01/10/2021” i.e. 1 Oct 2021 but not Jan 2021!
I think I have to define the date format of my data source to start with but I do not know how. Anyone can shed some light? Thanks.
Regards, CFung
Still the same unfortunately.
I have asked internally if we are allowed to share the qvd and indeed not. What I can share is as below, but that's the same as the excel file.
Hope these help. Many thanks.
Hello,
I have just added a Master calendar to my Data Load Editor and now things are working fine. I still do not know what went wrong with my previous setting. But adding the Master Calendar does help.
Many thanks!