Filtering a Load Table

Wed, 12 Dec 2012 19:25:23 GMT

I am doing a load using the following script and would like to do further filtering based on one of the fields in the load. I am trying to only show data where the Time_Month_Key is equal to the Current Month

The Time_Month_Key is formatted as 'YYYYMM'

How would I write the filter to do this? (See Section in Red Below)

HierarchyLookup:
Load
'Business_Unit',
'Director',
'Manager',
'Rep',
'Reporting_Team',
'Time_Month_Key',
'VP'
Resident vw_EOM_Sales_Leads_Metrics_Detai
where Time_Month_Key = date(Now());

Thanks

Tim

Re: Filtering a Load Table

MayilVahanan — Wed, 12 Dec 2012 19:36:27 GMT

where Time_Month_Key = date(Now(),'YYYYMM');

because date(now()) gives DD/MM/YYYY default format. so as per your YYYYMM format, so must change the format..

topic Filtering a Load Table in QlikView

Filtering a Load Table

Re: Filtering a Load Table