topic Re: loaded dates appear as values in QlikView

loaded dates appear as values

nevilledhamsiri — Wed, 25 Nov 2020 16:16:04 GMT

At times when data are loaded, dates are shown as values as shown below. I have given the date format in excel such as (mm/dd/yy). In otherwards, date was entered as 08/31/2017 1st the Month then the Date & Year after.

Thanks

Neville

Re: loaded dates appear as values

vinieme12 — Sat, 26 Aug 2017 07:10:44 GMT

Right click on chart >> properties>>go to Number tab >> select field from left pane >> select format to Date

That's is all

Re: loaded dates appear as values

vinieme12 — Sat, 26 Aug 2017 11:54:57 GMT

if your query is resolved please close the thread by marking the response as correct

Qlik Community Tip: Marking Replies as Correct or Helpful

Re: loaded dates appear as values

sunny_talwar — Sat, 26 Aug 2017 12:34:46 GMT

‌It appears that you are using DATE as a dimension here.... I would suggest using a calculated dimension here...

Date(DATE)

Re: loaded dates appear as values

sunny_talwar — Sat, 26 Aug 2017 12:36:25 GMT

Vineeth - isn't this too early for query resolution message? The OP might not have even seen your response yet ...

‌

Re: loaded dates appear as values

vinieme12 — Sat, 26 Aug 2017 12:47:48 GMT

maybe and maybe not

Just checkout the number of threads the op has actually closed

nevilledhamsiri

Re: loaded dates appear as values

sunny_talwar — Sat, 26 Aug 2017 12:52:01 GMT

‌Hahahaha ya I know that... I have been at the receiving end of this ....