topic Re: Format in Straight Table in QlikView

Format in Straight Table

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

Hi All,

In a straight table i need to bold values on first occurrence of max value,
condition is all the columns has to compare trigger value(100) and it is should bold the first occurrence of max value
Example

First row : 100 > 94 and 100 > 120 and 100 > 97 (120 should be bold)

Second Row : 100 > 120 and 100 > 110 and 100 > 105 (120 should be bold)

Third Row : 100 > 90 and 100 > 97 and 100 > 110 (110 should be bold)

O/P should be

Thanks in advance

Re: Format in Straight Table

stabben23 — Mon, 16 Jan 2017 09:55:16 GMT

if(sum( aggr(sum(expression),Emp, Trigger))= max(TOTAL aggr(sum(expression),Emp, Trigger)),'')

use this in textformat in your Expression.

click on the + sign at Your expression to find it.

Re: Format in Straight Table

jonathandienst — Mon, 16 Jan 2017 10:04:02 GMT

You can use the text format property of the expression with expressions like:

=If(A > B And A > C, '') (for expression A)

=If(B > A And B > C, '') (for expression B)

=If(C > A And C > B, '') (for expression C)

Re: Format in Straight Table

tresB — Mon, 16 Jan 2017 10:09:30 GMT

May be like in attached sample.

Re: Format in Straight Table

Anonymous — Mon, 16 Jan 2017 10:34:19 GMT

Hi Jonathan ,

Thanks for the reply, worked perfectly as expected ,

If(A > B And A > C, '') (for expression A)

modified your expression

f(A > B And A > C and A > TrigerValue, '') for expression A and remaining expressions

Thanks to all