Hi guys,I am new to Qlik Sense and I'm facing difficulties while trying to extract the date from the given string.can anyone help me with this?.I have posted some of the strings below from which the date should be extracted.
welcome to qlik !! i wish you should get some knowledge from qlik help regarding the date functionality
In this scenario , we have to tell the qlik sense that the given string is in right format of date
1. learn about Date # () 2. Date ()
How to convert in to date format : Type A - which can be done in front end Backend : load * inline [ String_date Monday, January 02, 2012 Tuesday, January 03, 2012 Wednesday, January 04, 2012 ]; After loading , open the chart section
Step 1: Create a variable in front end with the given the set below as Date1 right(trim(SubField('String_date',',',2)),2)&'/'& left(trim(SubField('String_date',',',2)),3)&'/'& trim(SubField('String_date',',',3))