topic Re: Date in QlikView

Date

Sun, 01 Mar 2015 09:24:46 GMT

Hi ALl

Iam attaching my qlikview file , U can see that i have a staright table which has the expression name as YTD ABP ,In my excel data i have the values only for 2015 April , but in my dashboard it is shwowing the values for 2014 also .

Can some one help me over this

Re: Date

robert_mika — Sun, 01 Mar 2015 10:23:36 GMT

Could you share your data/file?

Re: Date

MK_QSL — Sun, 01 Mar 2015 16:57:16 GMT

There is something wrong in your load script..

Create a list box of FiscalMonth, FiscalYear and Booking Sales Value ABP.. which will give you idea about what is wrong in your scrip..

Re: Date

Sun, 01 Mar 2015 17:15:56 GMT

HI Manish thanks for your reply , i tried all the option but could not resolve the problem ,

Can u plz tell me iam using this script for temp calendar is this correct .

SET vFiscalYearStartMonth = 4;

LET vStartDate = Num(YearStart(Today(),-2));

LET vEndDate = Num(YearEnd(Today()));

FiscalCalendar:

LOAD

Dual('Q' & Ceil(FiscalMonth/3), Ceil(FiscalMonth/3)) AS FiscalQuarter, // Fiscal Calendar Quarter

Dual(Text(Date(MonthEnd(Date), 'MMM')), FiscalMonth) AS FiscalMonthName; // Fiscal Calendar Month Name

LOAD

Year(Date) AS Year, // Standard Calendar Year

Month(Date) AS Month, // Standard Calendar Month

Date(MonthEnd(Date), 'MMM') AS MonthName, // Standard Calendar Month Name

Dual('Q' & Ceil(Month(Date)/3), Ceil(Month(Date)/3)) AS Quarter, // Standard Calendar Quarter

Mod(Month(Date) - $(vFiscalYearStartMonth), 12)+1 AS FiscalMonth, // Fiscal Month

Right(YearName(Date,0,$(vFiscalYearStartMonth)),4)as FiscalYear;

//YearName(Date, 0, $(vFiscalYearStartMonth)) AS FiscalYear; // Fiscal Year

LOAD

Date($(vStartDate) + RangeSum(Peek('RowNum'), 1) - 1) AS Date,

RangeSum(Peek('RowNum'), 1) AS RowNum

AutoGenerate vEndDate - vStartDate + 1;

Re: Date

smilingjohn — Mon, 02 Mar 2015 10:38:54 GMT

HI Wrestler u need to concatenate year and month

Try this

Year(Date)&'|'&Month(Date)&'|'&DivCode&'|'&[Sales Office Dec]&'|'& [Sales Office] as ABPKEY

Hope this works

Re: Date

Roop — Mon, 02 Mar 2015 11:41:49 GMT

You need:

in ABP:

month(Date)&'|'& year(Date) &'|'&DivCOde&'|'&[Sales Office Desc]&'|'&[Sales Office] as Link

in Billing:

month(Date)&'|'& year(Date) &'|'&DivCOde&'|'&[Sales Office Desc]&'|'&[Sales Office] as Link

This will add the year into the link and it should function correctly