Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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').
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').
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.............
See this blog post: Accumulations
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)
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.