topic Re: Why Only when i select A all the row is highlighted ? But when select E 1 row not highlighted. in QlikView

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

paulyeo11 — Thu, 17 Jul 2014 07:01:46 GMT

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

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

paulyeo11 — Thu, 17 Jul 2014 07:03:12 GMT

My QV doc

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

Anonymous — Thu, 17 Jul 2014 07:09:16 GMT

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

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

paulyeo11 — Thu, 17 Jul 2014 07:14:34 GMT

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

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

Anonymous — Thu, 17 Jul 2014 07:23:53 GMT

Hello Paul,

I am using Qlikview 11 SR2

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

paulyeo11 — Thu, 17 Jul 2014 07:31:36 GMT

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

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

Anonymous — Thu, 17 Jul 2014 07:35:19 GMT

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

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

antose — Thu, 17 Jul 2014 11:59:00 GMT

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))))

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

paulyeo11 — Thu, 17 Jul 2014 16:00:35 GMT

Hi AnTo

Your propose expression also working fine.

Thank

Paul