Issues with MinString and Strings with lower/upper cases

[EliGohar]

Hi all,

Using the following expression I'm trying to get the first source (ABC order) with the maximum date (with a URL that is not null):

MinString({<Date={"<=$(=Date(Max(Date),'DD/MM/YYYY'))"}, [Dwell_Heat_Map_URL]-={"-"}>} Source)

This is the list of sources I have

What I get in that case is Camera1112, which is not the min string. I suppose to get airport1 source.

I guess it's something to do with Upper and lower cases.

Can you advise me how to overcome this issue?

Thanks 🙂

[sunny_talwar]

You could have opened the attached qvf file and checked it for yourself :).

Anyways I get this

And this is because we only have a single value available on the max date which is Intersection1. I hope you are not expecting to see airport1.

[EliGohar]

@sunny_talwar  yeah you right about the qvf but in the client environment i'm not allowed to import external files from the web 🙂

thank you so much sunny for all your help and patience.

[sunny_talwar]

No problem. So, did you get what you wanted?