1 Reply Latest reply: Dec 21, 2016 10:13 AM by Santiago Respane RSS

    To Display only Certain Row in Pivot Table

    San Li Ho
      ItemValue
      A100
      B200
      C300
      D400
      E500

       

      Above is a pivot table in QlikSense. Could you please advise the formula to be put in in order to show only Item B and E?

        • Re: To Display only Certain Row in Pivot Table
          Santiago Respane

          You can do this via Set Analysis or with calculated dimensions.

           

          With set analysis would be something like this:

          • In dimensions add Item
          • In the expression add =SUM({<Item={"B","E"}>}Value)

           

          With calculated dimension it would be something like this:

          • In dimension add calculated dimensions like this: IF(Item = "B" or Item = "E", Item)
          • In expression add: SUM(Value)

           

          I prefer using set analysis over calculated dimensions for better performance with big data sets.

          Please let me know if this helps.

          Kind regards,