topic Re: Conditional Text Format in Table in QlikView

Conditional Text Format in Table

gf — Sat, 16 Nov 2024 20:59:30 GMT

Hello all,

It's maybe a stupid questions but i just can not figure it out. I have a pivot table and i want that each cell in column "Betrag_Abgrenzung" where "Subkategorie" is empty to be displayed as bold.

It tried it like in the picture below but it doesn't work.

Re: Conditional Text Format in Table

zhadrakas — Thu, 25 Apr 2019 06:37:35 GMT

try like
if(len(trim(SUBKATEGORIE))=0, '<B>')

Re: Conditional Text Format in Table

gf — Thu, 25 Apr 2019 06:42:40 GMT

Nice to hear from you again tim and thanks for the fast reply, but unfortunately nothing changes.

Reagrds

Re: Conditional Text Format in Table

zhadrakas — Thu, 25 Apr 2019 06:54:52 GMT

i tried it with sample data and it works for me.

For Dimension (BETRAG) and as Expression (sum(BETRAG))

is used this Expression in Text Format

=if(len(trim(SUBKATEGORIE))=0, '<B>')

Re: Conditional Text Format in Table

Vengatesh — Thu, 25 Apr 2019 06:58:31 GMT

Try any one of this:

if(Isnull(SUBKATEGORIE), '<B>')

if(SUBKATEGORIE='', '<B>')

Re: Conditional Text Format in Table

gf — Thu, 25 Apr 2019 07:28:17 GMT

As you see, i tried it the same way....

Re: Conditional Text Format in Table

gf — Thu, 25 Apr 2019 07:30:41 GMT

@Vengatesh no changes visible with your solution....

Re: Conditional Text Format in Table

zhadrakas — Thu, 25 Apr 2019 07:31:02 GMT

please try if it works as an Expression like sum(BETRAG_ABGRENZUNG)
Which QlikView Version do you use?

Re: Conditional Text Format in Table

gf — Thu, 25 Apr 2019 07:37:03 GMT

Version 12.20.20700.0

Re: Conditional Text Format in Table

gf — Thu, 25 Apr 2019 07:40:44 GMT

The funny thing is, in the same project, i had the same requirement but with Italic and it worked like expected.

Re: Conditional Text Format in Table

Vengatesh — Thu, 25 Apr 2019 09:17:53 GMT

what style are you using?

Provide some sample data.

Re: Conditional Text Format in Table

gf — Thu, 25 Apr 2019 09:19:23 GMT

Modem

Re: Conditional Text Format in Table

gf — Thu, 25 Apr 2019 09:21:55 GMT

Here you are.