Discussion Board for collaboration on QlikView Layout & Visualizations.
For layout reasons I would like to suppress identical dimension values in a straight table if they are shown one below the other.
As an example like in the table below the country names should only appear in the rows of their first occurence (1st, 4th, 7th).
Use a pivot table to get this effect easily.
Or if you need a straight table, open the chart properties -> dimensions -> expand the Country dimension and edit the expression for the 'text color'
to conditionally show a transparent color use the argb() function with '0' as the first parameter:
=if( RowNo() <> 1, argb(0,125,125,125))
There are advantages in using a straight table that you might not want to lose.
try changing the color to white if the above(dimension field)=dimension field
Just a trick
Thanks to all, the tricks with the "rowno()" as well as the "above()" work fine and do suppress the correct rows.
Unfortunately, however, as soon as I incorporate those functions QV will somehow ignore my second sort priority. The objective is to display all records within a group (i.e. the rows with identical dimensional values) in a descending order based on a (rather complex) calculated measure.
I am using QlikView for Windows Desktop Version 11.20.12742.0 SR10
(Free version, since I am still evaluating, downloaded about one month ago from qlik.com)