Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to show all dimensions in Pivot table in Qlik Sense

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

1 Reply
shraddha_g
Partner - Master III
Partner - Master III

Try

Count({1}EnquiryNumber)