5 Replies Latest reply: Feb 22, 2018 1:49 AM by Qlik Sapiens RSS

    Set Analysis? Find Formula Value for Dimension Value

    Qlik Sapiens

      Dear all,

       

      I have the following graph with test data:

       

       

      Now I want to show a text box like this:

       

      This one was created using the following formula:

      'The Dim1 value with the highest value in sum(Expression1) is: ' max(aggr(sum(Expression1), Dim1)) // here I want to see "C", not the formula value.

       

      However, I do not want to show the formula value of 134707, but the dimension value "C". How can I do this? With set analysis?

       

      Please find attached the QVW. Thank you very much in advance.

       

      QS