Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
arsalanam
Creator
Creator

Hide Certain Rows in Pivot

Need to "hide" Other and Unassigned rows in below pivot table without affecting either of Total rows. Please, note Industry column below is a second dimension but dragged to make it look like a column.

Is such a scenario possible ?

Thanks.

RegionIndustryTotalCorporationUnassignedPublicBanking
Total88%61%93%63%69%
Americas13%9%3%58%49%
Europe0%27%94%86%48%
Asia15%44%55%31%18%
Other24%54%31%19%41%
4 Replies
Not applicable

Hi,

I think you should try to hide it by using an if statement. For example: if(Region<>'' or Region<>'Other',Region) . This way the unassigned and other regions won't be displayed in your table. Let me know whether it worked or not!

Best,

Tibor

arsalanam
Creator
Creator
Author

Hi Tibor,

It hides those values but also changes the Total values as well, need to keep them the same.

Not applicable

Look at this thread. That should solve your problem.

Hiding rows based on condition

arsalanam
Creator
Creator
Author

Ramkumar,

As mentioned, I have a pivot table (not Straight) ... and the post mentions hiding a row based on an expression value, my condition is to hide a row based on a Dim value and still not affect the Total.

Thanks.