Limit Filter to Certain Objects

rittermd — Wed, 18 Feb 2015 13:33:14 GMT

I have a filter that I created which is based on an expression. I want this filter to only affect one table in my dashboard. The table should be affected by all filters.

Here is the expression.

=aggr(if(((((YEAR(DueDate)-PeriodYear)*12+(MONTH(DueDate)-PeriodMonth)))>=0 AND measure_result='1')

AND (((YEAR(DueDate)-PeriodYear)*12+(MONTH(DueDate)-PeriodMonth))<=3 AND measure_result='1'),'0-3 months',

if(((((YEAR(DueDate)-PeriodYear)*12+(MONTH(DueDate)-PeriodMonth)))>3 AND measure_result='1')

AND (((YEAR(DueDate)-PeriodYear)*12+(MONTH(DueDate)-PeriodMonth))<=6 AND measure_result='1'),'4-6 months',

if(((((YEAR(DueDate)-PeriodYear)*12+(MONTH(DueDate)-PeriodMonth)))>6 AND measure_result='1')

AND (((YEAR(DueDate)-PeriodYear)*12+(MONTH(DueDate)-PeriodMonth))<=12 AND measure_result='1'),'7-12 months',

if(measure_result='0','-Due Now',)))),member_id,measure_description,measure_result,DueDate)

I am basically filtering rows based on the date calculation.

Is this possible to do? I know that you can do this based on a field. Not sure if it can be done with an expression.

Thanks

topic Limit Filter to Certain Objects in QlikView

Limit Filter to Certain Objects