topic Re: Suppress identical dimension values in straight table in QlikView

Suppress identical dimension values in straight table

Tue, 03 Mar 2015 13:01:33 GMT

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

Re: Suppress identical dimension values in straight table

JonnyPoole — Tue, 03 Mar 2015 13:41:02 GMT

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

Re: Suppress identical dimension values in straight table

awhitfield — Tue, 03 Mar 2015 13:44:43 GMT

Try Using a Pivot Chart instead

Re: Suppress identical dimension values in straight table

giakoum — Tue, 03 Mar 2015 14:53:28 GMT

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

Re: Suppress identical dimension values in straight table

Wed, 04 Mar 2015 09:53:11 GMT

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.

Re: Suppress identical dimension values in straight table

giakoum — Wed, 04 Mar 2015 11:35:42 GMT

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

what version are you using?

Re: Suppress identical dimension values in straight table

Wed, 04 Mar 2015 11:52:54 GMT

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)

Re: Suppress identical dimension values in straight table

giakoum — Wed, 04 Mar 2015 14:47:57 GMT

that is the latest one.

Can you post a sample app?

Re: Suppress identical dimension values in straight table

Thu, 05 Mar 2015 08:06:06 GMT

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

Re: Suppress identical dimension values in straight table

giakoum — Thu, 05 Mar 2015 11:43:39 GMT

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

even in SR10

Re: Suppress identical dimension values in straight table

Thu, 05 Mar 2015 12:03:50 GMT

Ok, thanks for that statement.

Since I am quite new to QV: Should I report this (mis-)behaviour somewhere or will you take care of that?

Re: Suppress identical dimension values in straight table

giakoum — Thu, 05 Mar 2015 12:47:12 GMT

We have already reported that.