topic Re: Data Format conversion in QlikView

Data Format conversion

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

Hi Everyone,

Can any one please help me on conversion of below formated Month field to Date Field.

It contains Month - Year and Number format values.

Thanks in Advance

Re: Data Format conversion

Anil_Babu_Samineni — Tue, 12 Sep 2017 15:19:39 GMT

May be this?

Alt(Date(Date#(Month, 'MMM-YYYY'),'MMM-YYYY'), Date(Num(Month),'MMM-YYYY'))

Re: Data Format conversion

Peter_Cammaert — Tue, 12 Sep 2017 15:24:11 GMT

To turn those numbers into dates, use a Date() formatting function in your Load statement.

The first half of your list box contains values that are exclusively present as strings, not as Dates. The difference between the two sets points to a script loading from different sources. Use proper parsing ( e.g. Date#() ) and formatting functions (e.g. Date() ) to turn both date sources into properly formatted values.

Re: Data Format conversion

bhavvibudagam — Tue, 12 Sep 2017 15:24:37 GMT

Thank you Anil