topic Re: Date format. in QlikView

Date format.

Sat, 27 Jun 2015 06:32:13 GMT

Hi.

my requirement is to create master calander and quarters from below table i tried but if i applyed any date function it is showing blank no value iam not able to understand.. calander should be in the form of fisical year

example:

year 2013-2014---------2014-2015, Q1,Q2,Q3,Q4

if i seelect 2013 may that particular may total expendoture should show in bar chart

kindly help

Re: Date format.

Digvijay_Singh — Sat, 27 Jun 2015 06:38:25 GMT

I don't see data loaded in the qvw you shared, can you verify once..

Re: Date format.

Sat, 27 Jun 2015 06:48:44 GMT

sorry for that posting new qvd plz help me in that requirement

Re: Date format.

settu_periasamy — Sat, 27 Jun 2015 07:25:35 GMT

Hi,

there is no data in your attachment.

Reload the data, Save it, then post the qvw file again.

Re: Date format.

settu_periasamy — Sat, 27 Jun 2015 08:27:18 GMT

Hi,

Try the attachment. It would be helpful.

Re: Date format.

PrashantSangle — Sat, 27 Jun 2015 08:34:08 GMT

Hi,

For financial year use yearname()

like yearname(datefield,0,4)

and use date(), monthyear(), year() and day()

Regards,

Re: Date format.

Sat, 27 Jun 2015 08:52:37 GMT

thanku settu .

this is same result i except but in quarter only one quarter is there because

1/1/2013 0:00

1/1/2014 0:00

1/1/2015 0:00

2/1/2013 0:00

2/1/2014 0:00

these are in mm/dd/yyyy but u took dd/mm/yyyy where should i change to get four quarter

Re: Date format.

settu_periasamy — Sat, 27 Jun 2015 09:51:38 GMT

Hi,

Try to change this..

LOAD Distinct Date(Floor(Date#(pay_yearmonth, 'M/D/YYYY hh:mm')),'D/M/YYYY') as Date;