7 Replies Latest reply: Jun 18, 2018 5:18 AM by Rangam Seshadri RSS

    Hide dimension element in pivot table

    Rafał Dudka

      Hi,

       

      I have created the following Qlik Sense pivot table:

       

      CountryStateCityAmount
      USA8 000
      Alabama4 500
      Montgomery1 000
      Birmingham2 000
      Mobile1 000
      Hoover500
      Quebec1 000
      1 000
      Ontario2 500
      2 500

       

      I want to hide rows with empty City. Totals and subtotals shoud be left as is .

       

      Any idea how to solve this?

       

      Regards,

       

      R