topic Re: How to high light row even when the amount is zero ? in QlikView

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

paulyeo11 — Thu, 21 Aug 2014 04:58:15 GMT

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

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

paulyeo11 — Thu, 21 Aug 2014 04:59:56 GMT

Hi All

my QV doc

Paul

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

sujeetsingh — Thu, 21 Aug 2014 05:00:40 GMT

Try like this

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

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

sujeetsingh — Thu, 21 Aug 2014 05:02:08 GMT

Failed to open the doc error

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

paulyeo11 — Thu, 21 Aug 2014 05:03:55 GMT

Hi Suj

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

Paul

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

paulyeo11 — Thu, 21 Aug 2014 05:08:11 GMT

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

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

sujeetsingh — Thu, 21 Aug 2014 05:11:14 GMT

Here it is

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

jagan — Thu, 21 Aug 2014 05:31:04 GMT

Hi Paul,

Try like this

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

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

Hope it helps you.

Regards,

Jagan.

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

paulyeo11 — Thu, 21 Aug 2014 05:42:17 GMT

Hi Jagan

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

Paul

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

sujeetsingh — Thu, 21 Aug 2014 05:42:54 GMT

Paul,

Jagan has given you the right concept.

Here is your sample and it works fine