Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Champion III
Champion III

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
Highlighted
Champion
Champion

14 Replies
Highlighted
Champion
Champion

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

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

For 2014 post the sample data.

Highlighted
Champion III
Champion III

but am getting error while usng the above date field

PFA  ..

in frnt end filterpane showng date format as 41816 lik dat

thanks

Highlighted
Champion
Champion

Have you done it at script level?

I done have QlikSense, not be able to QVF.

If you can share QVW or qvd?

Highlighted
Champion III
Champion III

these all my qvds.

PFA

Highlighted
Champion
Champion

Highlighted
Champion III
Champion III

thanks balraj..its wrkng fine

Highlighted
Champion
Champion

Highlighted
Champion III
Champion III

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

Highlighted
Champion
Champion

which field and which qvd?