topic Re: Qlikview Date Problem in QlikView

Qlikview Date Problem

Wed, 03 Sep 2014 11:52:53 GMT

Hello - Very new to this and really need help with dates. I have a column which has dates formatted like this

06/2014

Dates are being loaded from SQL and EXCEL

The date format for SQL load is correct and left justified, however my dates from Excel are right justified (even though they look the same)

Please could someone assist ?

This is the code to load from Excel

    [Anticipated Launch date],
     date(addmonths([Anticipated Launch date],IterNo()-1),'M/YYYY') as yearmonth,
     [Expected 3 Year Sales Value],
     [Expected 3 Year Sales Value]/36 AS PeriodValue
    while IterNo() <= 36;

I am trying to format the YEARMONTH to left justified

Thank you in advance !!!

Re: Qlikview Date Problem

datanibbler — Wed, 03 Sep 2014 12:00:39 GMT

Hi Emma,

very probably (judging by the fact of the data being right-justified in Excel), that data is being transferred to QlikView as a numeric value. Check that. In that case, you'd have to adapt it using the DATE() function. Then you should have the same as from your SQL load.

HTh

Best regards,

DataNibbler

Re: Qlikview Date Problem

PrashantSangle — Wed, 03 Sep 2014 12:03:40 GMT

Hi,

Just Use

Date(Date#(dateFieldName,'MM/YYYY'),'MM/YYYY') as NewDate

Regards

Re: Qlikview Date Problem

MayilVahanan — Wed, 03 Sep 2014 12:07:11 GMT

Try like this

Date(Date#([Anticipated Launch date],'MM/YYYY'),'MM/YYYY') as YearMonth

u can use with Alt function

Alt(Date([Anticipated Launch date],'MM/YYYY'), Date(Date#([Anticipated Launch date],'MM/YYYY'),'MM/YYYY') ) as YearMonth

Re: Qlikview Date Problem

Wed, 03 Sep 2014 12:27:22 GMT

Thank you max dreamer but I'm struggling to know where to put this in my code as I have a date function in there already ?