Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sureshqv
Esteemed Contributor 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
balrajahlawat
Esteemed Contributor

Re: RE:Data showing

PFA..

14 Replies
balrajahlawat
Esteemed Contributor

Re: RE:Data showing

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

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

For 2014 post the sample data.

sureshqv
Esteemed Contributor III

Re: RE:Data showing

but am getting error while usng the above date field

PFA  ..

in frnt end filterpane showng date format as 41816 lik dat

thanks

balrajahlawat
Esteemed Contributor

Re: RE:Data showing

Have you done it at script level?

I done have QlikSense, not be able to QVF.

If you can share QVW or qvd?

sureshqv
Esteemed Contributor III

Re: RE:Data showing

these all my qvds.

PFA

balrajahlawat
Esteemed Contributor

Re: RE:Data showing

PFA..

sureshqv
Esteemed Contributor III

Re: RE:Data showing

thanks balraj..its wrkng fine

balrajahlawat
Esteemed Contributor

Re: RE:Data showing

sureshqv
Esteemed Contributor III

Re: RE:Data showing

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

balrajahlawat
Esteemed Contributor

Re: RE:Data showing

which field and which qvd?