Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
We've requirement to convert attach SQL script into qlikview.. I have attached SQL script.. Most of the logic change into qlikview but can someone help to convert part 1 and 2 below in attach logic..
file attach - sql text
and qlikview which already written
1. {fn ltrim( {fn concat(CAST(PerformanceRecordDate.Fiscal_Year AS INTEGER) , {fn concat('/', {fn ltrim(CAST(PerformanceRecordDate.Fiscal_Year AS INTEGER)+1)})} )})}
2. ( ( (PerformanceRecordDate.Fiscal_Year * 100 ) + PerformanceRecordDate.Fiscal_Week_No ) in (SELECT yrwk (INTEGER) FROM
(SELECT ((Fiscal_Year * 100) + Fiscal_Week_No ) AS yrwk, ROW_NUMBER() OVER (ORDER BY yrwk DESC) AS rn
FROM v_calendar
QUALIFY rn BETWEEN 1 AND 13
WHERE calendar_dt BETWEEN
(SELECT min(Calendar_Dt) FROM v_Calendar WHERE fiscal_year =' 2015'
AND fiscal_week_no = 11) - ((6)-1)*7
AND
(SELECT min(Calendar_Dt) FROM v_Calendar WHERE fiscal_year = ' 2015'
AND fiscal_week_no = 11)
GROUP BY Fiscal_Year, Fiscal_Week_No) as yrwktbl) )
)