topic Re: Display the oldest date in a text object based on values in QlikView

Display the oldest date in a text object based on values

regowins — Fri, 13 Mar 2015 23:55:12 GMT

Hi,

I have a sample set of data values as shown below. My requirement is to dynamically display only the date of the oldest overdue work# in a text object. In this case it would be 2/14 or Feb 2014 .

Thanks for the help!

Re: Display the oldest date in a text object based on values

Anonymous — Sat, 14 Mar 2015 01:33:12 GMT

Hi Ashwin,

not sure I totally understand but try this.

1. In your load script, create new field with actual date, something like that

...

MakeDate( 2000+ num(right([MM/YY],2)), left([MM/YY], Index([MM/YY],'/',1)-1 )) as workdate,

....

2. Then create a textbox with this expression

=min({$<Overdue_flag={1}>} workdate)

This will output 02/01/2014

is this what you have in mind?

Re: Display the oldest date in a text object based on values

regowins — Sat, 14 Mar 2015 04:52:30 GMT

Thanks!!! That will work.

I guess I was wondering if there was a way to accomplish this without having to make changes to the script with only the given data. That may not be possible.

Re: Display the oldest date in a text object based on values

Anonymous — Sun, 15 Mar 2015 00:40:07 GMT

it is possible but your expression will be more complicated than it needs to be and you should strive to do all transformations you can in your load script.

Remember that you normally want to spend 60% of your time on a data model and 40% on the visualizations - data model is the key!