Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

anshivank
New Contributor

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
Honored Contributor III

Re: How to show all dimensions in Pivot table in Qlik Sense

Try

Count({1}EnquiryNumber)

Community Browser