topic please need urgent reply in QlikView

please need urgent reply

Thu, 09 May 2013 06:24:15 GMT

Hi ...please help me this issue...Actually i have a dimension Fiscal week (please find below attachment) with data 1,2,3,4,5,6,7,......but in my case i need to show data like W1,W2,W3,W4...is this possible?

Re: please need urgent reply

kumarnatarajan — Thu, 09 May 2013 06:27:29 GMT

Hi,

Just concate W string in your Fiscal week field

Ex: ='W'&Fiscal_week

Re: please need urgent reply

Thu, 09 May 2013 07:45:45 GMT

hi ..i am nt getting exact result please find the below attachment , i am sending the script for 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,

LOAD

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

(qvd

);