Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
bob654321
New 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
Highlighted

Re: Hide a row in the Pivot table ?

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)
Highlighted
bob654321
New Contributor

Re: Hide a row in the Pivot table ?

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