topic Filter a table with a calculated dimension in QlikView

Filter a table with a calculated dimension

Sun, 03 Apr 2011 18:15:59 GMT

Dear Friends,

Why this line does not work:

a calculated dimension: =if(DateTask= $(=aggr(max(DateTask),WorkOrder)),WorkOrderTask, null())

Thanks in advance,

Javier Pozo

Miguel_Angel_Baeyens — Sun, 03 Apr 2011 21:26:45 GMT

Hello Javier,

You don't need to use $() in a condition like that, so try

=if(DateTask = aggr(max(DateTask),WorkOrder), WorkOrderTask, null())

Hope that helps

Tue, 05 Apr 2011 16:28:41 GMT

Angel,

You are right it works.

Thanks again

Javier Pozo