Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try
Count({1}EnquiryNumber)