topic Re: a dynamic colour in a line chart in QlikView

a dynamic colour in a line chart

Mon, 20 Oct 2014 13:53:00 GMT

Hello! Can you tell me please, what am doing rong? I wanted the line to be blue if the debt is >0 and red if <0

=ColorMix1(if(Sum(debt)>=0,0,1),LightBlue(),red())

Re: a dynamic colour in a line chart

MK_QSL — Mon, 20 Oct 2014 13:57:38 GMT

Presentation Tab

Click on + sign on your expression

Write below in Background color

IF(SUM(debt)>0,Blue(),Red())

Re: a dynamic colour in a line chart

JonnyPoole — Mon, 20 Oct 2014 13:58:01 GMT

Is this formula performed on the dimension on the expression ? For dimensions, you may need to aggregate by date using aggr()

Also consider a simpler formula

if(Sum(debt)>=0,LightBlue(),red())

Re: a dynamic colour in a line chart

Mon, 20 Oct 2014 14:02:07 GMT

its performed on the expression, the colour af background .. but it works strange.. the colour is changed not by passing nul...

Re: a dynamic colour in a line chart

Mon, 20 Oct 2014 14:04:51 GMT

Manish, the problem is that i did that way, but it doesnt work correctly=(

Re: a dynamic colour in a line chart

MK_QSL — Mon, 20 Oct 2014 14:07:58 GMT

Your sample data or sample apps would be helpful to give you correct answer...

Re: a dynamic colour in a line chart

JonnyPoole — Mon, 20 Oct 2014 14:26:58 GMT

Are your numbers in the data model cumulative totals ? Is the expression formula also sum(Sales) or something different ?

Re: a dynamic colour in a line chart

Mon, 20 Oct 2014 14:29:51 GMT

Yes, it is cumulative totals and the expression formula is also sum(debt)

Re: a dynamic colour in a line chart

JonnyPoole — Mon, 20 Oct 2014 14:33:50 GMT

You may need to sum up all preceding values as well then

Consider replacing Sum(Debt) with the following that would aggregate all previous values.

rangesum(above(Sum([debt]),0,rowno()))

Re: a dynamic colour in a line chart

Tue, 21 Oct 2014 13:03:22 GMT

i didn't really undestand , if i should put it in the expression, or in the backround colour as well?

Anyway, understood thats its not the best way to show debts, bars are more effective.. and though in a bar chart it clear, whats below zero, and whats above, its still interesting to make different colours..

Could you kindly look at my app, please?

Re: Re: a dynamic colour in a line chart

JonnyPoole — Tue, 21 Oct 2014 13:35:31 GMT

You can use the rangesum(above()) expression in the background color to handle expressions where you are using 'full accumulation'. You can also use the rangesum(above()) expression in lieu of the sum( field) with full accumulation in the expression formula as well. Your choice.

In the attached example, i used the latter and in the background color.

Let me know if its accumulating and coloring as you want.

Re: Re: a dynamic colour in a line chart

Tue, 21 Oct 2014 13:46:45 GMT

jpe , thanks!! thats what i need!! I would be indescribably gratefull, if you look at my other question abut same app..calculate the age of debt, fifo payment/

Thank a lot!!!