Why Only when i select A all the row is highlighted ? But when select E 1 row not highlighted.

[paulyeo11]

Hi All

I start a new post for above topic because of i have found some thing new.

I have a QV doc , when the column have zero value , the whole row will not be highlighted.

My Existing expression is :-

=if(Only({1}[Exec P&L Calculation])='c',Yellow())

My Old expression is below :-

=if([Exec P&L Calculation]='c',Yellow())

it work fine , but when i add a new column for compute the column 1 and 2 diff , i get extra row display on the above.

Hope some one can advise me how to remove those extra row. 

Paul

[paulyeo11]

My QV doc

[Anonymous]

I am unable to open this file, it shows it has some inconsistency, could you please heck and let me know if its correct.

[paulyeo11]

Hi Nita

You are using what version ? Yes you are right , it is due to missing value issue. i don't know how to make missing value also count .

Paul

[Anonymous]

Hello Paul,

I am using Qlikview 11 SR2

[paulyeo11]

Hi All

Can some one tell me are you able to open the QV doc ?

Hi Nita

Let wait and see other can open my QV doc.

Paul

[Anonymous]

Regarding missing values, can you apply isnull(or other functionality) and convert them to 0. Or suppress them.

[antose · Accepted solution]

Hi!

Your extra lines came from the code "if(Column(1)=0,1,"

Should you always shown 4 and 3 month back? (from the header =date(addmonths(max(YearMonth), -4), 'MMM-YYYY') & chr(10) & '' )

I'm lite bit of confused when i look in this application.

If you should, this can works.

=If(Column(1)<> Column(2), If(Column(1)=0,1,(Column(2)-Column(1))/(Column(1))))

[paulyeo11]

Hi AnTo

Your propose expression also working fine.

Thank

Paul