Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

kangaroomac
Contributor II

Set Analysis in Qlik Sense

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])

1 Solution

Accepted Solutions
MVP
MVP

Re: Set Analysis in Qlik Sense

Try this:

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

3 Replies
MVP
MVP

Re: Set Analysis in Qlik Sense

Try this:

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

kangaroomac
Contributor II

Re: Set Analysis in Qlik Sense

That worked, thanks sunindia.

I see I used single quotes instead of double.

MVP
MVP

Re: Set Analysis in Qlik Sense

No problem

I am glad I was helpful.

Best,

Sunny