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: 
gleybson_calyx
Contributor III
Contributor III

Max Data within Set Analysis

Hello people,

I would like to know how to do to return the max (Date) within Set Analysis.

In the image below I show that when selecting the pro product it shows the value and when it does not have product select (Imagem2) it does not bring.

exeples I've already tried:

sum ({<YearMessageDay = {'$ (= MAX (YearMessage))}}}} VALUE)

sum ({<YearMindDay = {"$ (= MAX (YearMindDay))"}>} VALUE)

Imagem1

Comunidade01.png

Imagem2

comunidade02.png

1 Solution

Accepted Solutions
gleybson_calyx
Contributor III
Contributor III
Author

Funcionou assim:

FirstSortedValue({<Tipo = {'Entradas'}>}  VALOR,-DATA)

Fica a dica!

View solution in original post

4 Replies
gleybson_calyx
Contributor III
Contributor III
Author

sum( {<AnoMesDia = {'$(=MAX(AnoMesDia))'} >} VALOR )

sum( {<AnoMesDia = {"$(=MAX(AnoMesDia))"} >} VALOR )

gleybson_calyx
Contributor III
Contributor III
Author

Anyone have any suggestions?

gleybson_calyx
Contributor III
Contributor III
Author

Tabelao que preciso
nomedtvalornomedtvalor
abacate01/01/201810abacate02/01/20189
abacate02/01/20189abacaxi04/01/201816
abacaxi03/01/201815
abacaxi04/01/201816
gleybson_calyx
Contributor III
Contributor III
Author

Funcionou assim:

FirstSortedValue({<Tipo = {'Entradas'}>}  VALOR,-DATA)

Fica a dica!