Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
bob654321
Contributor
Contributor

Hide a row in the Pivot table ?

I need to hide the row that has the Bed Category = 'TOTAL'.  How can I do it without using suppress null option ?  The problem with using suppress null option is the denominators in one of the calculations shows zero if I use that option. so I need to have the Bed Category = 'TOTAL' for the denominator to work but somehow the TOTAL rows should be hidden from the report.

 

Capture.JPG

 

 

I'm using this sql below in my qvw .

 

Select Year,

Month,

Quarter,

Bed_Category,

Client,

MemberCount

from Category.qvd

CONCATENATE

Select Year,

Month,

Quarter,

'TOTAL' as ' Bed_Category,

Client,

MemberCount

from Category.qvd

 

The MemberCount field is the denominator used in the calculations and it is not dependent on the Bed_Category in the backend code, so the membercount will only display for the Bed_Category='TOTAL' but not for other bed categories.

 

2 Replies
Anil_Babu_Samineni

You can disable "Partial Sums" from Presentation tab.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
bob654321
Contributor
Contributor
Author

TOTAL is not generated using partial sum. It is another dimension value under Bed Category.