Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
Matt,
Thx for the solutions. I always worked with SSRS and I'm new to QV, but it's great to work with.