Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

paulyeo11
Valued Contributor II

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

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

summary row high lighted.png

1 Solution

Accepted Solutions
sebastiandperei
Valued Contributor

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

Sorry Paul, I was mistaked.

I guess you have used this "if" because of you want to show 100% when the Column(1) =0 AND Column (2) <>0. If you just do the first condition, it returns a value also if the second one is 0 too, and this is the cause of the "extra" rows.

You should use the following exp:

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

Please, try it and tell us!

(the first suggestion, wasn't useful for you?)

14 Replies
paulyeo11
Valued Contributor II

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

my QV doc.

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

paulyeo11
Valued Contributor II

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

My AccountSetup file

antose
Contributor II

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

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.

Skärmklipp.JPG.jpg

sebastiandperei
Valued Contributor

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

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
Valued Contributor II

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

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
Valued Contributor II

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

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
Valued Contributor II

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

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
Contributor II

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

Hi!

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

sebastiandperei
Valued Contributor

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

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



Community Browser