Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

How to high light row even when the amount is zero ?

Hi All

I have below expression which is working fine :-

=if([Exec P&L Calculation]='c','<B>')

This expression will blod the text . is working fine. As these row are summary row , i need to make the contract.

Now my issue is when on that month due to data is zero , it will not make the text bold. can some one help me adding some more script , so that even the amount is zero , it still make the text highlighted with bold.

Paul

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

Hi Paul,

Try like this

if([Exec P&L Calculation]='c' OR Alt([Exec P&L Calculation], 0)=0 ,'<B>')


OR


if([Exec P&L Calculation]='c' OR Len(Trim(([Exec P&L Calculation]))=0 ,'<B>')


Hope it helps you.


Regards,

Jagan.

View solution in original post

9 Replies
paulyeo11
Master
Master
Author

Hi All

my QV doc

Paul

sujeetsingh
Master III
Master III

Try like this

if([Exec P&L Calculation]='c' OR [Exec P&L Calculation]=0 ,'<B>')

sujeetsingh
Master III
Master III

Failed to open the doc error

paulyeo11
Master
Master
Author

Hi Suj

You are very fast , but it does not work. can you post the QV doc file which is working ?

Paul

paulyeo11
Master
Master
Author

i have create a new post , chk it is due to my side , pls wait.

sujeetsingh
Master III
Master III

Here it is

jagan
Luminary Alumni
Luminary Alumni

Hi Paul,

Try like this

if([Exec P&L Calculation]='c' OR Alt([Exec P&L Calculation], 0)=0 ,'<B>')


OR


if([Exec P&L Calculation]='c' OR Len(Trim(([Exec P&L Calculation]))=0 ,'<B>')


Hope it helps you.


Regards,

Jagan.

paulyeo11
Master
Master
Author

Hi Jagan

your first expression work fine , now my table look sexy. thank

Paul

sujeetsingh
Master III
Master III

Paul,

Jagan has given you the right concept.

Here is your sample and it works fine