3 Replies Latest reply: Jul 2, 2015 10:47 PM by Sunny Talwar RSS

    Set Analysis in Qlik Sense

    Ian McGivern

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