Discussion Board for collaboration on QlikView Scripting.
GEO&'.'&[Operating Area]&'.'&[Sales_Region]&'.'&Territory&'|'&upper(ACCOUNT_SEGMENT)&'|'&[NCV_Type]&'.'&[Hyperion Budget Unit]&'.'&SCBU&'|'&left(Fiscal_Period,4)&'-Q'&Right(Fiscal_Period,1)
'PNCV' AS [NCV_Type]
(ooxml, embedded labels, table is Data);
this is the code , but the fiscal period is in the image below,
Go to Solution.
Left(Fiscal_Period, 4) as fiscal_year,
Right(Fiscal_Period, 1) as Fiscal_Quarter,
You can split it like this in the script:
Left(Fiscal_Period, 4) as FiscalYear,
Right(Fiscal_Period, 1) as FiscalQuarter
try like this:
subfield(Fiscal_period,' ',1) as Fiscal_Year,
'Q'&subfield(Fiscal_period,' ',2) as Fiscal_Quater
I assume that you want 'Q' in fiscal quarter, so
'Q' & right(Fiscal_Period, 1) as Fiscal_Quarter,
My answer was even correct ...