2 Replies Latest reply: Sep 30, 2015 2:23 PM by Ramon Covarrubias RSS

    Pivot Table Measure Display Only at Line Item Level

    John Koegel

      Hi All,

       

      I am very new to Qlik Sense, and I am wondering whether there is a way to have a dynamically calculated Measure display at only the line item level of a Pivot Table. For example, can I calculate a range [max(ItemPrice) - min(ItemPrice)] only at the deepest aggregation level? Right now it simply displays at every level of aggregation, and at the highest level (Company) I see ranges of thousands of dollars when the actual line item ranges are very small.

       

      As a possible workaround, is there a way to apply to a background color expression to the deepest aggregation level only?

       

      Thank you in advance for the help.

       

      John