3 Replies Latest reply: Nov 17, 2009 10:31 AM by Miguel Angel Baeyens de Arce RSS

    Hiding of dimension in pivot table

    Arvind Tikku

      Hia all,

       

      I have created a pivot table and in that i have used one calculated dimesion for filtering purpose.

       

      What i want is i should not display that dimension in report but its importance is for filtering the results.

       

      How can i hide a dimension in a pivot table.

       

      Can you guys help me in this

       

      I went through api guide.qvw but couldn't find the macro

       

       

        • Hiding of dimension in pivot table
          Miguel Angel Baeyens de Arce

          You can use a Group of Dimensions which shows only the one you want to show in the chart/pivot table, but use it later in reports, or you can add a if statement to say when and how you want to show that dimension, if that's what you want.

            • Hiding of dimension in pivot table

              Hi

              Just to be clear, I think an IF statement to conditionally show a dimension is only available in Version 9.

              I don't know of a way in version 8.x to conditionally show a dimension on a pivot table or even to have it functioning but not showing, it can be done very simply on a straight table in the presentation tab.

              One option might be: Change the text colour to white and make the column size very small but you'd need to check what the impact of this is on the report as I don't ever use reports in QlikView.