Don't show all the values in the Straight/Pivot table

[jjordaan]

Hi all,I want to create a Straight or a Pivot table but I don't want to show all the values of the field where the table is based on.

Example:
The field where the table is based on contains let say 20 fields (See attachment) but I only want to show certain fields, let say 4 or 5.
What is the best way to do that.

Thanks for all the help.

[matt_crowther · Accepted solution]

There are several methods to do this:

1. A Calculated Dimension using an if() function to control the ones you want eg:

=if(match(MyField,'House','Car','Garage'),MyField)

2. In teh Properties Dialog > Presentation tab set the 'Max Number' to 5 to only show the top 5 records based on your Sort method.

Hope that helps,

Matt - Visual Analytics Ltd

Qlikview Design Blog; http://QVdesign.wordpress.com

@QlikviewBI

[jjordaan]

Matt,

Thx for the solutions. I always worked with SSRS and I'm new to QV, but it's great to work with.