Set Analysis date filter

shumailh — Mon, 25 Oct 2010 15:20:17 GMT

Hi All,

I am trying to get the report date which is the last month end date i.e. '09/30/2010'. I put this value in the variable throught the same table where all the Month end date present. please see the below code.


Script:
CardMast_Active:
LOAD Report_NO, LoadDate_Active, LoadDay_Active, bal, AIF FROM [$(Outputpath)CardMast_Active.qvd] (qvd);

MinMaxDates:
load
 minstring(LoadDate_Active) as StartDate,
maxstring(LoadDate_Active) as ReportDate
resident CardMast_Active

// now get the values...
 let ReportDate = peek('ReportDate',0) ;

Expression:
=COUNT({$<AIF = {'P'}, LoadDate_Active = {$(=Date($(#=ReportDate),'MM/DD/YYYY'))} >} AIF)

The above expression is not working.. [:S] please help

SV:Set Analysis date filter

gandalfgray — Mon, 25 Oct 2010 15:28:51 GMT

Try adding a couple of " like this:

=COUNT({$<AIF = {'P'}, LoadDate_Active = {"=$(=Date($(#=ReportDate),'MM/DD/YYYY'))"} >} AIF)

SV:Set Analysis date filter

shumailh — Mon, 25 Oct 2010 15:38:03 GMT

Good Man! u r such a help..cheers & Thanks

Shumail

topic SV:Set Analysis date filter in QlikView

Set Analysis date filter

SV:Set Analysis date filter

SV:Set Analysis date filter