Suppress identical dimension values in straight table

[#1]

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).

[JonnyPoole]

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:

EX:

=if( RowNo() <> 1, argb(0,125,125,125))

[awhitfield]

Try Using a Pivot Chart instead

[giakoum]

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

[#5]

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.

[giakoum]

this reminds me a little of a bug we had in some previous version.

what version are you using?

[#7]

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)

[giakoum]

that is the latest one.

Can you post a sample app?

[#9]

Pls find attached a sample app. I hope you can open it because until now I am working with the free desktop Version.

[giakoum]

unfortunately it looks like the bug is still there....

even in SR10