Help for a new user ...

[#1]

Hello everyone,

I am quite new in Qlik sense and I tried something and I am not able to understand why it doesn't work :

Avg( {< [Semaine-sem] =  Max([Semaine-sem])  >} [Météo])

Once this one is solved, I would like to go a bit further : the field [Semaine-sem] go from 1 to n but sometimes after a certain amount of Semaine-sem, the field [Météo] is empty so I'd like to exlude these data.

Thanks for any help and sorry for my bad English

[agigliotti]

try:

Avg( {< [Semaine-sem] =  {"=Max([Semaine-sem])"}  >} [Météo])

[OmarBenSalem · Accepted solution]

It's rather :

Avg( {< [Semaine-sem] =  {"$(=Max([Semaine-sem]))"}  >} [Météo])

[#4]

thanks Omar, the syntax is correct, it works great