Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
It's rather :
Avg( {< [Semaine-sem] = {"$(=Max([Semaine-sem]))"} >} [Météo])
try:
Avg( {< [Semaine-sem] = {"=Max([Semaine-sem])"} >} [Météo])
It's rather :
Avg( {< [Semaine-sem] = {"$(=Max([Semaine-sem]))"} >} [Météo])
thanks Omar, the syntax is correct, it works great