topic displaying max(date) as non-selectable text in QlikView

displaying max(date) as non-selectable text

Anonymous — Tue, 18 Oct 2011 15:15:21 GMT

Hi,

I want to display in the app how current the data mart data is using the maximum activity_date value.

I can do this in a statistics box, but then the value is selectable and I do not want users to filter data by clicking on that.

So I created a text box with the following, BUT the month portion is displaying as 00.

(If I change the mm/dd to dd/mm then the 00 displays where te mm is moved to.)

= timestamp(max(ACTIVITY_DATE),'mm/dd/yyyy hh:mm')

What is the best way to do this computation and display it as read-only/not selectable?

Thanks!

displaying max(date) as non-selectable text

jagannalla — Tue, 18 Oct 2011 15:20:29 GMT

=Max(Date(ACTIVITY_DATE,'MM/DD/YYYY hh:mm:ss'))

try this..

if you don't want to filter the ACTIVITY_DATE based on the other selections remove the relationship with this field during loading itself.

displaying max(date) as non-selectable text

Anonymous — Tue, 18 Oct 2011 15:36:53 GMT

Actually, I do want a relationship with Activity Date, but only through a selection on it via a multibox.

Ideally, I'd like to use the Stats box and make that object read-only, but I don't see a way to

do that. I've used text boxes to display other things (a count of course section, a sum of the number os activities) and this has worked fine. But it is puzzling that the month portion of the date is somehow lost when I use the max function on the text object. I get 00/06/2011 when it should be 06/06/2011. If there were any sort of truncating going on, I would have expected it to be on the day number rather than the month number...

displaying max(date) as non-selectable text

swuehl — Tue, 18 Oct 2011 17:47:03 GMT

Have you used the format code as given by Jagan N?

It is important to use 'MM' for month, since 'mm' is representing minutes. Are your minutes '00' also?

displaying max(date) as non-selectable text

Anonymous — Tue, 18 Oct 2011 18:09:31 GMT

Yes there is case sensitivity in the formatting, an the minutes were 00 which is why the lowercase mm returned the wrong value. Thanks so much!