topic Re: please need urgent reply in QlikView

please need urgent reply

Thu, 09 May 2013 06:16:31 GMT

Hi..Can any one help me this issue....Actually i have a dimensions Fiscal year(2010,2011,2012,....) , Fiscal Quarter(Q1,Q2,Q3,Q4,...) ,Fiscal Month (Jan,Feb,March,...) but my case is by using any of those i need to show Fiscal Week like (W1,W2,W3,W4...)...Is it possible....

Re: please need urgent reply

er_mohit — Thu, 09 May 2013 06:31:52 GMT

Try this

'W' & Ceil(Week(TempDate)/8) as Fiscalweek

TempDate is my date field

Re: please need urgent reply

Thu, 09 May 2013 06:36:35 GMT

where i have to give this condition...

Re: please need urgent reply

er_mohit — Thu, 09 May 2013 06:36:59 GMT

in script level where your other fields you make like for fiscal year,and for month there you write this

and you will get fiscalweek fieldname when reload your data

you have to write this in your edit script for short cut press ctrl+E

where you mentioned your date field there you put this code make sure you chanfe the date field

hope it helps

Re: please need urgent reply

Thu, 09 May 2013 07:19:20 GMT

hi ..i am nt getting exact result please find the below attachment , i am sending the dimdate qvd go through that once let me know how to get that exact result like FiscalWeek data should be like W1(for the 1st week),W2(for the second week),W3(for the 3rd week)......please

Regards,

Re: please need urgent reply

anandathome — Thu, 09 May 2013 07:27:33 GMT

Hi Shobha,

Please attache the qvd.

-Anand.

Re: please need urgent reply

Thu, 09 May 2013 07:38:02 GMT

Hi..this the script i have for the dim date

LOAD

Day,
CalendarWeek,
FiscalWeek,
Month,
CalendarQuarter,
FiscalQuarter,
CalendarYear,
FiscalYear
FROM

(qvd

);

Re: please need urgent reply

anandathome — Thu, 09 May 2013 08:21:09 GMT

I am assuming that you have one FullDate column in your calendar/date dimension.

Use the below LOAD script

LOAD

Day,

CalendarWeek,

FiscalWeek,

Month,

CalendarQuarter,

FiscalQuarter,

CalendarYear,

FiscalYear,

'W' & Week(Date(FullDate,'YYYY-MM-DD')) as WeekNo1,

'W' & If((Week(Date(FullDate,'YYYY-MM-DD')) - (Week(Date('2013-04-01'))-1))>0,(Week(Date(DOCDATE,'YYYY-MM-DD')) - (Week(Date('2013-04-01'))-1)),52+(Week(Date(DOCDATE,'YYYY-MM-DD')) - (Week(Date('2013-04-01'))-1))) as WeekNo2

FROM

(qvd

);

Note: WeekNo1 is when your calendar year and fiscal year are same.

WeekNo2 is when your fiscal year starts on 1st April.

Let me know in case of any issue.

-Anand