Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

highlight and bold values that are different

Hi, how can I highlight and bold values that are different in a table? See below:

Untitled.png

1 Solution

Accepted Solutions
jsingh71
Not applicable

Re: highlight and bold values that are different

Try This:

1.png

2.png

--Jai

5 Replies
cuv
Not applicable

Re: highlight and bold values that are different

Is your table a straight table?

If yes, please check if fits your needs

Not applicable

Re: highlight and bold values that are different

Hi so sorry, I can't open qlikview files that are not created by me, so do you mind sending screenshots instead? Thanks

gupta_n8
Not applicable

Re: highlight and bold values that are different

In background of Expresiions,

you can use as

suppose Exp 1>> sum(qty1)

              Exp 2 >> sum(qty2)

if(sum(qty1)<>sum(qty2),yellow())

and similary in text format use

if(sum(qty1)<>sum(qty2),'<b>')

jsingh71
Not applicable

Re: highlight and bold values that are different

Try This:

1.png

2.png

--Jai

cuv
Not applicable

Re: highlight and bold values that are different

jsingh71 have taken the screenshots