Qlik Community

Qlik Sense App Development

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

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Not applicable

Using expression in set expression

Hi all,

I haven't done lot of set analysis recently and I just got a problem.

I trying to get the average of a value on the first date of my set analysis.

I am using the following expression :

= avg( {$<date = {$(=Min(date))}>} value )

But I got an empty result.

Can any of you see what I am doing wrong ?

Thanks in advance.

Tags (2)
1 Solution

Accepted Solutions
Not applicable

Re: Using expression in set expression

Hi again,

I knew it was easy I was just going a bit nuts on the $ sign syntax.

So the answer to this :

avg({$<date={"$(=min(date))"}>} value)

If anyone ever have the same problem remember that the official documentation is confusing. I found the correct syntax here .

View solution in original post

2 Replies
Not applicable

Re: Using expression in set expression

Hi again,

I knew it was easy I was just going a bit nuts on the $ sign syntax.

So the answer to this :

avg({$<date={"$(=min(date))"}>} value)

If anyone ever have the same problem remember that the official documentation is confusing. I found the correct syntax here .

View solution in original post

Re: Using expression in set expression

Can you try this:

=Avg({$<date = {"$(=Min(date))"}>} value)


or


=Avg({$<date = {"$(=Date(Min(date), 'DateFieldFormatHere'))"}>} value)