topic Best way display single Date? in QlikView

Best way display single Date?

Wed, 26 Feb 2014 11:19:56 GMT

Hi,

I have a list of date, and i just need to pick the max(date) in on top of the sheet as an object.

The date will as like latest data date on my report.

What is the best way to do it? Thanks.

Regards

Benjamin See

Re: Best way display single Date?

sundarakumar — Wed, 26 Feb 2014 11:38:53 GMT

Create a text box with

=max(date)

-Sundar

Re: Best way display single Date?

aveeeeeee7en — Wed, 26 Feb 2014 11:40:23 GMT

Dear Benjamin

See the Attachment

Regards

Aviral Nag

Re: Best way display single Date?

Wed, 26 Feb 2014 11:42:43 GMT

Create A variable Called

vMaxDate=Max(Date)

Re: Best way display single Date?

Wed, 26 Feb 2014 11:46:46 GMT

i think u want show What is latest Reload time of your data then u can

use following text in Text Box

it will give latest Reload time

='The Latest Reload Time is

'& ReloadTime()

Re: Best way display single Date?

greg-anderson — Wed, 26 Feb 2014 11:49:09 GMT

Hi, Benjamin. I agree with what has been stated- create a variable in script that grabs the max(date) after the relevant data is loaded.

One word of caution with date variables: beware of the format of the stored value. I use many date-related variables in my reporting. When I look at these variable values through the QV menu, I see (for example) '2/26/2014' for Today().

If I try to use this date for comparison QV will sometimes process it as an arithmetic fraction (2 / 26) / 2014.

For this reason, I store all date values as Num(date), if I'm actually storing the date rather than a text representation of it. Then I can extract anything I need and format the date in any way I choose without worrying about ambiguity in comparative analyses.

I know there are other ways around this, but this one works best for me. Cheers!

Re: Best way display single Date?

Thu, 27 Feb 2014 02:52:59 GMT

Hi, thanks for all the idea.

Regards

Benjamin See