topic Re: calculated date in QlikView

calculated date

Anonymous — Tue, 04 Dec 2012 14:21:44 GMT

Dear all,

I'm trying to calculate two dates starting from the selected date, but I'm making some mistakes.

I've a list box with the operation date

Choosing a date, I would display into a graph, the total operations for the selected date, the total operation for 7 days ago and two weeks ago, like this:

Nr.Operation for select.date Nr.operat. Nr. operat.

30 november 2012 23 nov 2012 16 nov 2012

100 110 90

I tried the following:

count({<Operation_DATE={$(=only((date(num(getfieldselections(Operation_DATE))-7))))}>} OperationID)

but it doesn't work, it doesn't recognize the calculated date

Help please

Thanks in advance

Re: calculated date

CELAMBARASAN — Tue, 04 Dec 2012 14:27:53 GMT

Try with this

count({<Operation_DATE={$(=Date(Max(Operation_DATE)-7)))}>} OperationID)

Re: calculated date

MayilVahanan — Tue, 04 Dec 2012 14:33:39 GMT

Try like this

count({<Operation_DATE={$(=Date(Max(Operation_DATE)-7))}>} OperationID)

If format difference

count({<Operation_DATE={$(=Date(Max(Operation_DATE)-7,'DD-MMM-YYYY'))}>} OperationID)

Hope it helps

Re: calculated date

Anonymous — Tue, 04 Dec 2012 18:18:18 GMT

Unfortunatly it doesn't work.

It seems that it recognize the correct date, but I don't have data into the related column. As operation date, I selected 27/11/2012. The calculated date is correct, but no data are displayed

= count({<Operation_DATE={20/11/2012}>} Operation)

Re: calculated date

MayilVahanan — Tue, 04 Dec 2012 18:22:00 GMT

then what you need on this situation?

Re: calculated date

Anonymous — Tue, 04 Dec 2012 18:25:22 GMT

Hi,

I found the problem:

count({<Operation_DATE={"$(=Date(Max(Operation_DATE)-7,'DD-MMM-YYYY'))"}>}

It's necessary to add the double commas as wrote above.

Thanks to everyone who spent time to help me !!