Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

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

Re: Max Data within Set Analysis

Funcionou assim:

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

Fica a dica!

4 Replies
gleybson_calyx
New Contributor III

Re: Max Data within Set Analysis

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

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

gleybson_calyx
New Contributor III

Re: Max Data within Set Analysis

Anyone have any suggestions?

gleybson_calyx
New Contributor III

Re: Max Data within Set Analysis

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

Re: Max Data within Set Analysis

Funcionou assim:

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

Fica a dica!

Community Browser