3 Replies Latest reply: Sep 16, 2016 11:42 AM by Gabriel Oluwaseye RSS

    highlighting highest numbers

    Robert Winkel

      Any way to be able to do this?

       

        • Re: highlighting highest numbers
          Carson Walker

          With Qlik Sense Pivot Tables - You can highlight the Cell Values based on your criteria.

           

          This example shows highlighting the cells for all sales over $5000. 

           

          This type of color expression needs to be placed in the Background Color Expression area of the Measure details on the right side of sense.

           

          highlight.PNG

          • Re: highlighting highest numbers
            Stefan Wühl

            To highlight the max value, you can use something as background color expression like


            =If( Sum(Value)=Max(TOTAL Aggr( Sum(Value), Product, Customer)),Yellow())


            Sum(Value) being the expression in the chart and Product, Customer the dimensions.

            • Re: highlighting highest numbers
              Gabriel Oluwaseye

              Hi,

               

              Maybe try this below expression, select EDIT (little pencil icon at top right) then select Appearance then Colors then change the colors to By Expression.

               

              IF(Sum([Value])=RANGEMAX(TOP(TOTAL Sum([Value]),1,NOOFROWS(TOTAL))),YELLOW())

               

              Where YELLOW() is whatever color you want.

               

              Here is the full function for Top and Bottom

              IF(Sum([Value])=RANGEMAX(TOP(TOTAL Sum([Value]),1,NOOFROWS(TOTAL))),YELLOW()

              ,IF(Sum([Value]) = RANGEMIN(TOP(TOTAL Sum([Value]),1,NOOFROWS(TOTAL))),RED()))