topic How do you modify date display in Current Selections Box? in QlikView

How do you modify date display in Current Selections Box?

Thu, 10 Feb 2011 17:43:54 GMT

Hi there,

I'm having problems modifying my Date field in the current selections box. it's displaying the TIME as well as the DATE and i'm only interested in viewing the DATE. Below is a screen shot of what it looks like. Anybody know how to fix this? I think it's an easy fix but I can't seem to figure it out.

How do you modify date display in Current Selections Box?

lucas4bi — Thu, 10 Feb 2011 17:51:16 GMT

Go on Document Properties and on the sheet "Number" select SaleDate and set the format DATE

How do you modify date display in Current Selections Box?

matt_crowther — Thu, 10 Feb 2011 17:52:30 GMT

I'm assuming that it's related to how the actual field itself is formatted as I have the below basic Current Selections Box where I haven't had to do any additional formatting / tweaking to get it to where you need:

So to get to that point simply add a date(SalesDate,'dd/mm/yyyy') as SalesDate in your load script.

Hope that helps,

Matt - Visual Analytics Ltd

How do you modify date display in Current Selections Box?

Thu, 10 Feb 2011 17:52:53 GMT

Hello Mike,

You have to do this at the data level I beleive. In the Load statement where you have (YourDateField) do a Date(your fieldname), 'MM DD YYYY') as NewDate and then do a reload. This way it picks up only the mentioned dates and you can use them the way across the application. As I have read it and if you want the time in some charts for some reason then you have to do it a different way as this removes the time away for good..

ANDY

How do you modify date display in Current Selections Box?

Thu, 10 Feb 2011 18:12:05 GMT

Hi Luca. this was the quickest and easiest solution offered. It works and thanks for your help.