How to show all dimensions in Pivot table in Qlik Sense

[Anonymous]

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

[shraddha_g]

Try

Count({1}EnquiryNumber)