Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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))))
My QV doc
I am unable to open this file, it shows it has some inconsistency, could you please heck and let me know if its correct.
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
Hello Paul,
I am using Qlikview 11 SR2
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
Regarding missing values, can you apply isnull(or other functionality) and convert them to 0. Or suppress them.
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))))
Hi AnTo
Your propose expression also working fine.
Thank
Paul