Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I don't see data loaded in the qvw you shared, can you verify once..
sorry for that posting new qvd plz help me in that requirement
Hi,
there is no data in your attachment.
Reload the data, Save it, then post the qvw file again.
Hi,
Try the attachment. It would be helpful.
Hi,
For financial year use yearname()
like yearname(datefield,0,4)
and use date(), monthyear(), year() and day()
Regards,
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
Hi,
Try to change this..
LOAD Distinct Date(Floor(Date#(pay_yearmonth, 'M/D/YYYY hh:mm')),'D/M/YYYY') as Date;