5 Replies Latest reply: Mar 16, 2015 9:53 AM by Francois Tremblay RSS

    Set Analysis but with a dimension for answer

    Francois Tremblay

      Hello everyone,

       

      I'm just starting with Qlik Sense and it's my first message that I leave, so thanks in advance for your help and insight.

       

      I'm making a text box, in which, I would like to show first of all the Highest unit Price paid for an item, followed by the name of the customer who paid that price, the period and year, in which that sale occurred. I got the max(UnitPrice) Ok, but it's the name of customer and date that I can't find. I found the formula Set Analysis when your looking for a measure, but what about the Dimension info related to my max(UnitPrice).

       

      Again thanks for your help!