why only when i select company=A all summary row highlighted work fine ?

[paulyeo11]

Hi All

I have a QV doc , which give me very funny issue. which i am not able to figure out ! That is when i filter company = A , it work fine , because all summary row is highlighted with yellow and is working fine .But when i select all other company not working fine.

Below  image shown how the excel file control which row i wanted to high lighted which c fill in the cell.

Hope some one can give me hints how to trouble shoot this .

Paul

[paulyeo11]

my QV doc.

I have try to isolate the issue , but still unable to know where it the problem.

[paulyeo11]

My AccountSetup file

[antose]

Hi!

I just made a fast check and it looks like your Color Expression is False. Therefore you don't get Yellow back.

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

As you can see is it only true on A, B, C in the test below. My suggestion is to check your data.

[sebastiandperei]

Paul, in your example, SALES & PROMOTION - S & D isn't related to SOURCE GL=ADL  ("E" Source) at the date selected, only is related with this source at the date you are selecting in SET ANALISYS (in the example, Dec 2013)

Then, you need to "exclude" selections in the expression of the colour, both, dimmention and expression.

Replace the color one by:

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

Do the same for Bold Font.... Try this!!

[paulyeo11]

Hi Seb

Many thank for your your sharp observation and detect and offer me solution which is working fine. I still not sure why need to add exclude , and from the another user reply , he highlighted my data issue....

Now i see another issue pop up , that is for this table i am only compute P&L variable , when i add column display % Diff LY vs CY , my table get head wire , as it display BS variable . it there any way i can avoid ?

[paulyeo11]

Hi AntoSe

you got the point , in fact i have Account Setup file , which i see i have mark c , the fact is only certain company have issue , but then all company share one account setup file .... so i still lost.

[paulyeo11]

Hi AnToSe

Can you pls send me the QV doc ? I mean you manage to create 2 expression to chk for no value on it.

Because i confirm you are right this is due to missing value for the most recent month.

I need to use your expression to figure out how to solve my problem.

Paul

[antose]

Hi!

Here it is (just same expression as you have on the color code)

[sebastiandperei]

Hi Paul!

In your expression:

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

You are "telling" to Qlikview that if Column (1) =0, show 100%. This is why it shows the rows that you don't want to see. This expression would be Just:

(Column(2)-Column(1))/(Column(1))