Calculated expression to remove certain days

Wed, 19 Dec 2012 12:08:45 GMT

Hi,

I have a straight table and thanks to this forum have a way of getting the count of all the Unassigned call from the database. The expression I use is:

count({<call_status_full={'Unassigned'}>}suppgroup)

The above expression check the call_status_full field and if it equals unassigned, it tells me how many calls there are for each support group in field suppgroup.

However I have been asked if I can expand the expression so it picks up unassigned call only if the field lastactdate is 14 days or more older than the current system date.

EG: If a call was last updated on the system (lastactdate) on 01/12/2012 and the date today is 19/12/2012, this call would show as 1 on the table

However if a call was last updated on the system (lastactdate) on on 16/12/2012 and today is 19/12/2012, this would not show on the table.

Regards,

Jon Ditchfield

Re: Calculated expression to remove certain days

Gysbert_Wassenaar — Wed, 19 Dec 2012 12:47:49 GMT

try something like:

count({<call_status_full={'Unassigned'}, lastactdate={'<=$(=date(today()-14))'}>}suppgroup)

topic Calculated expression to remove certain days in QlikView

Calculated expression to remove certain days

Re: Calculated expression to remove certain days