Discussion Board for collaboration related to Creating Analytics for QlikView.
I have a waterfall chart where values which are positive are green and values which are negative are red.
This works as expected.
My issue becomes more complex when i try to add the condition for the Total Column (in yellow).
The requirement is to have the Total coluum in another colour.
I am using the Dimensionality() =0 to identify the total column. This works outside of the IF statement.
However when I add this to the exisiting condition nothing happens.
Am I not seeing something obvious?
Any help appreciated.
Here is the expression for the background colour and the current graph
Bonus equestion how do I identify the others colum in a table where the others is a result of a limited dimension.
May thanks in advance!
Go to Solution.
Use below expression.
if(RowNo()=1 or Dimensionality()=0,0,RangeSum(Above(sum(Value),1,RowNo())))
Background Color:- if(Dimensionality()=0,Yellow(),if(Column(1)>0,Green(),Red()))
please find attached application for reference.
I feel like I'm missing something here, so I'll just ask: in your condition, if Column(1)>0, the result is always Green(). Your total is >0. Why shouldn't it be green?
Or firstly thanks for your answer. It's much appreciated. I understand what you are saying.
The dimensionality of the Total colum is 0 so I was hoping that the Dimensionality()=0 would set the Black.
I see that my logic is wrong. Have you any idea how to go about this?
It is achievable. I don't have application handy.Can you please post your demo application?
Thanks so much!! This work. I should have played with my statement more. Thanks again for your help