Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Help for a new user ...

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

1 Solution

Accepted Solutions
omarbensalem
Esteemed Contributor

Re: Help for a new user ...

It's rather :

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

3 Replies
agigliotti
Honored Contributor II

Re: Help for a new user ...

try:

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

omarbensalem
Esteemed Contributor

Re: Help for a new user ...

It's rather :

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

Not applicable

Re: Help for a new user ...

thanks Omar, the syntax is correct, it works great