Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Selecting value of field for max(timestamp) (Set Analysis)

Hi,

here is my problem. The software version (field Version) for a BoardID (field Board_ID) can be sent several times a day (field(signaltime)) --- see picture.

So for each BoardID i can have more then one version linked and one Software Version can be linked to several signaltimes.

Now I want to have the version for a BoardID which was sent the last time. I couldnt figure out how to do it. I tried Set Analysis with max(signaltime), but id didnt work, since max(signaltime) just gives a max date but not the timestamp and a version can be sent several signaltimes a day.

Does anyone know how to make this work?

Many thanks.

Mila

1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

Mila

You nmay have put the parameters in the wrong order. Try:

firstsortedvalue(version, signaltime)

The sort weight is the second parameter.

Hope this helps

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

7 Replies
fosuzuki
Partner - Specialist III
Partner - Specialist III

hi,

Can't see the picture...

Regards

Fernando

Anonymous
Not applicable
Author

thanks for the hint. Here is the picture to the problem.

Problem.jpg

nagaiank
Specialist III
Specialist III

You can get this using the FirstSortedValue() function, returning BoardID using -signaltime as sort-weight.

Anonymous
Not applicable
Author

I tried the function firstsortedvalue like this

firstsortedvalue(signaltime, version)

and it didnt work, since the field version is not a numeric field, but a text field. 😞

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

HI,

   I dont know this will work in your case or not, but you can give a try using Maxstring() function.

Regards,

Kaushik Solanki 

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
jonathandienst
Partner - Champion III
Partner - Champion III

Mila

You nmay have put the parameters in the wrong order. Try:

firstsortedvalue(version, signaltime)

The sort weight is the second parameter.

Hope this helps

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Anonymous
Not applicable
Author

Thanks Jonathan,

it works now like i wanted.