Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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)