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.