How to load rolling Period data in Qlikview

qlikview
load
reporting

#1

Hi,

I have an ODBC connection to load data in Qlikview App. I want to load only last 6 months data in the app on a rolling basis. For example, In Jan’15, I will load data from Aug’14 to Jan’15 and In Dec’14, it is Jul’14 to Dec’15. Please help to perform this.

Thanks,
Satish


#2

Satish,

You can pass criteria of last 12 months in Where clause of SQL statement.

Regards,
Sunil