Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Chanty4u
MVP
MVP

RE:Data showing

Hi all,

I have date field like Start date and year weekend date like,

LOAD

    PROJ_ID,

    //PROJ_SHORT_NAME,

    //DESCRIPTION,

    TASK_CODE,

    //TASK_NAME,

    RSRC_NAME,

    RSRC_SHORT_NAME,

    STARTDATE,

    Year(STARTDATE) as Syear,

    Month(STARTDATE) as Smonth,

     Date(STARTDATE) as Sdate,

    WeekEnd(STARTDATE) as WeekEndDate,

    ENDDATE,

    REMAININGUNITS

FROM [lib://Qvdsource/p6_forecast_rsrc_spread.qvd]

(qvd);

when i go to front end date field is shwng like 41816 ..and  my strt date is  08-jan-2015 but in frnt end ...weekend data is shwng frm 28-jun-2014....evn i dnt hve data for 2014

help me out

thanks in advance

suresh

1 Solution

Accepted Solutions
Anonymous
Not applicable

14 Replies
Anonymous
Not applicable

you can change the format of your End Date Field like:

Date(EndDate,'DD-MMM-YYYY') as EndDate..

For 2014 post the sample data.

Chanty4u
MVP
MVP
Author

but am getting error while usng the above date field

PFA  ..

in frnt end filterpane showng date format as 41816 lik dat

thanks

Anonymous
Not applicable

Have you done it at script level?

I done have QlikSense, not be able to QVF.

If you can share QVW or qvd?

Chanty4u
MVP
MVP
Author

these all my qvds.

PFA

Anonymous
Not applicable

PFA..

Chanty4u
MVP
MVP
Author

thanks balraj..its wrkng fine

Anonymous
Not applicable

Chanty4u
MVP
MVP
Author

but the date of 2014 is showng even i dont hve 2014 in my actual data ...?

Anonymous
Not applicable

which field and which qvd?