topic Re: convert Date field values in QlikView

convert Date field values

Wed, 25 Nov 2020 16:16:04 GMT

i want to convert Date field values like 19-07-20116 to 19-July-2016

and also i want to display particular dates only instead of displaying entire date field in list box or table box

Can any one please share the solution

Re: convert Date field values

Gysbert_Wassenaar — Wed, 20 Jul 2016 08:08:51 GMT

Well, that's going to be tricky. Unless 20116 is a typo. I'll assume it is. If the date value is a real date and not just a text string that looks like a date you use the Date() function: Date(MyDateField, 'DD-MMMM-YYYY').

If the date value is a string value then you first need to use the Date# function to turn it into a date value: Date(Date#(MyDateField,'DD-MM-YYYY'), 'DD-MMMM-YYYY').

Re: convert Date field values

Fri, 22 Jul 2016 06:23:59 GMT

Thank you so much Gysbert.it was working .

Question:i have a Sale field in a straight table.i want to add firstl sale value in first record to sale value in second record and display the total in second record and same on 3rd and 4th and display in 4th record.............

by using accumulation we can add all dimension values but here i want to add two-two values.please share the solution.............

Re: convert Date field values

Gysbert_Wassenaar — Fri, 22 Jul 2016 07:28:33 GMT

See this blog post: Accumulations

Re: convert Date field values

Sun, 24 Jul 2016 03:18:45 GMT

Thank you Gysbert.

Question 1:Can you Please Explain the entire Qlikview Data modeling Procedure (What are the regular steps needed to perform data modeling)?

Question 2:Can You please describe the End-End Realtime Project Architecture(Project Flow) like

(Please give me answers for the following questions)

How i can get the requirement?
{ In which format they will provide the requirement document?
who will provide the spec document to a Developer?
who will provide the database details?
how can we Extract the data from multiple data sources in QV Application?
How can we integrate the data that comes from multiple data sources In QV?
What are Data Modeling steps needed for critical data modeling?
what are regular functions used for Data modeling?
After Development and Before deploying what are the steps going on in a project?
Who will send a document to Testing team?
who will Perform SIT & UAT ?What is SIT and UAT ?
What are the steps needed for SIT?
What are the steps needed for UAT?
if any issues occur in a project who will provide the help to a developer?
Who is sever and who is Publisher?
what is The role of Server and Publisher?
Is Admin will maintain a team? }

Re: convert Date field values

oknotsen — Sun, 24 Jul 2016 13:11:36 GMT

All these questions have nothing to do with your initial topic; date conversion.

Half of these questions have nothing specific to do with QlikView (or Qlik Sense). Some are even basic software development.

So I am locking this topic.

I suggest you make a topic for specific (product related) questions (and not all in 1 topic as they are not all related), but not before using the search option (or even Google) and do some basic reading.