topic Re: Filter for the current month in App Development

Filter for the current month

srinu_qliksense — Sun, 30 Jul 2017 09:43:55 GMT

Hi,

I have report with last five year of data.

It is taking much time while loading the report.

Instated of total data, can we put a filter for the current month data only need to be populated in the report.

we have filter in the report like year and month.

Re: Filter for the current month

Chanty4u — Mon, 31 Jul 2017 09:32:13 GMT

write the where condition in script like

where Date>='01-jun-2017' ;

Re: Filter for the current month

rahulpawarb — Mon, 31 Jul 2017 09:46:44 GMT

May be this:

Data:
LOAD *
WHERE Date(Date) >= MonthStart(Today())
AND   Date(Date) <= MonthEnd(Today());
LOAD * INLINE [
Date, Sales
01/04/2017, 123000
02/04/2017, 456000
03/04/2017, 789000
04/04/2017, 123400
05/04/2017, 789100
06/04/2017, 123450
07/04/2017, 789120
08/04/2017, 123456
09/04/2017, 789123
];

Regards!

Rahul Pawar

Re: Filter for the current month

srinu_qliksense — Wed, 02 Aug 2017 10:05:40 GMT

let assume we have a qvd file which having total data of last five years.

In report we are loading total 5 years data.

In filter panel can we set such that it will list only current month data when i am opening the report.

Assume that i have datarange picker extension in my report.

it has to list the current month data by default.