Set Analysis in Qlik Sense

[kangaroomac]

Hi There,

Anyone know why the following won't return a value in an expression in Qlik Sense?

Avg({<

  [Dimension]={'MaxString([Dimension])'}

    //[Dimension]= {'Value'}

        >}[Measure])

When I try it without the commented section ([Dimension]= {'Value'}) I get the desired result.

I've also tried without the single quotes (Dimension and result of MaxString are non-numeric) with no avail:

Avg({<

  [Dimension]={MaxString([Dimension])}

    //[Dimension]= {'Value'}

        >}[Measure])

[sunny_talwar · Accepted solution]

Try this:

=Avg({<[Dimension]={"$(=MaxString(Dimension))"}>}[Measure])

[kangaroomac]

That worked, thanks sunindia.

I see I used single quotes instead of double.

[sunny_talwar]

No problem

I am glad I was helpful.

Best,

Sunny