How to mark double values in a table

jjbom1990 — Wed, 25 Nov 2020 16:16:04 GMT

Hi guys,

I am not able to fix my problem. I have the following table

it consists out of 3 dimensions and 1 expression. The experssion is not a calculation it is just there to show a value and have certain selections ignored:

=MaxString({<SchoolYear,GroupName, SchoolName>}GroupName)

I would like to have the background color react if the same SchoolYear of the same GroupName is within the table. I would like to give both or one a background color.

I have tried the following background color definition in the expression:

=if(count(total<SchoolYear> distinct [SchoolYear])>1,RGB(255,0,0))

I found this in another question, but it doesnt seem to be working. And I can't figure out what to do.

I tried it both with a pivot table and a straight table

When I am using the pivot and have it all collapsed it gives the maxstring for the schools and color them both red. This is not the desired outcome.

Someone probably has this fixed, or sees the problem within seconds, whilst I have been tinkering with this for quite some time.

Thanks in advance.

Re: How to mark double values in a table

florentina_doga — Mon, 22 Aug 2016 11:26:30 GMT

try this

if(count(total <SchoolYear> SchoolYear)<>count(distinct SchoolYear), RGB(255,0,0))

Re: How to mark double values in a table

florentina_doga — Mon, 22 Aug 2016 11:27:56 GMT

hope his help

topic Re: How to mark double values in a table in QlikView

How to mark double values in a table

Re: How to mark double values in a table

Re: How to mark double values in a table