1 Reply Latest reply: Nov 16, 2017 3:42 AM by Shraddha Gajare RSS

    How to show all dimensions in Pivot table in Qlik Sense

    Shivank Sharma

      Hi Guys,

       

      I am new to Qlik sense. I am using a Pivot table to show my Measures and Dimesions.

       

      Dimension: Status

      Open

      Saved

      Submitted

      OverDue

       

       

      Measure: Count(EnquiryNumber)

       

      The problem I am facing is if I have Enquiries which are in Open and Saved status only then my Pivot table is showing only two rows in Dimensions i.e. for Open and Saved only. I want to Show all rows for Dimension Status i.e. 4 in my case.

       

      Please help me how can I achieve this.

       

      Thanks,

      Shivank Sharma