topic Re: Filter load on date in QlikView

Filter load on date

Wed, 20 Aug 2014 11:03:11 GMT

I have the following script for one of my DIMS:

DIMFinancialPeriod:

SELECT date as FinancialPeriod

, [Year] as 'Year'

, [quarter] as 'Quarter'

, left([month],3) as 'Month'

,left([month],3) + ' ' +[Year] as 'MonthYear'

,[Year] + ' ' + left([month],3) as 'YearMonth'

FROM Dates

where date between '2013-04-01' and '2013-06-30'

Is it possible to pass a param into the where statements for the date which is not having to be alerted in the script when the QVW is reloaded? In addition could this be something that could be driven by like a admin screen?

Thanks

Re: Filter load on date

tresB — Wed, 20 Aug 2014 11:10:12 GMT

Once you create ODBC/OLEDB connection you can use it directly as it is in qlikview like:

SQL Select <your command>; qv will actually make it be executed by the connection string engine.

Re: Filter load on date

Wed, 20 Aug 2014 12:28:25 GMT

sorry could you elaborate?