topic Re: reply urgent please in QlikView

reply urgent please

Thu, 09 May 2013 07:59:01 GMT

Hi ...Can any one help me this ....Actually i have a dimension FiscalWeek (please find the below attachment for better understand) consisting data 1,2,3,4,5....but my issue is i need to disply it like W1 For the 1st week ,W2 For the 2nd week ,W3 For the 3rd week........please help me this.

Re: reply urgent please

vikasmahajan — Thu, 09 May 2013 08:18:37 GMT

Find Solution

vikas

Re: reply urgent please

anandathome — Thu, 09 May 2013 08:27:37 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

Re: reply urgent please

Thu, 09 May 2013 09:39:10 GMT

Hi Anand...i am not getting the result

please what i want to show is ...just go throuh the attache qvd load that and select the FiscalWeek in that we will get the data like 1,2,3,4,5..

rather than that i want to show for the 1st week W1 ,for the 2nd week W2.... it is possible pls let me know...

Re: reply urgent please

calvindk — Thu, 09 May 2013 09:53:07 GMT

Just do

='W' & FiscalWeek

or in script

'W' & FiscalWeek as WFiscalWeek

Re: reply urgent please

er_mohit — Thu, 09 May 2013 10:08:47 GMT

you only have to write in dimension where your fiscalWeek value comes

'W' & FiscalWeek

or if you want to create fiscal Week in backend then try this in edit script

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

here TempDate is my Date Field

hope it helps you

Re: reply urgent please

Thu, 09 May 2013 10:10:06 GMT

If i use that means will get the result like W1,W2,W3,W4......................W50,W51......just W will add to all right , but my case is for the 1st week W1 and for the second week W2....like that , need to reduce the data...please give me helpful answer

Re: reply urgent please

Thu, 09 May 2013 10:17:04 GMT

I tried this but getting error while reloading the script...like TempDate is nt found ..and in charts itself data is not coming , please check my attached qvd and let me know how to do it ...

Re: reply urgent please

er_mohit — Thu, 09 May 2013 10:35:19 GMT

hiii

load your qvd then do it like mine only field does not change anything

only this' 'W' & FiscalWeek as FiscalWeek'

try this

LOAD Day,

CalendarWeek,

'W' & FiscalWeek as FiscalWeek,

Month,

CalendarQuarter,

FiscalQuarter,

CalendarYear,

FiscalYear

FROM

C:\Users\Mohit\Downloads\DimDate.QVD

(qvd);

Re: reply urgent please

anandathome — Thu, 09 May 2013 11:27:53 GMT

Hi Shobha,

this is what you are exactly looking for, I guess. If there is any other requirement combined with this please tell us.

When you say first week, we understand that it is the first week of financial year.

If you could explain your actual requirement with example, people here may be able to help in right direction