topic Re: Hide repeated values when using accumulation in chart in QlikView

Hide repeated values when using accumulation in chart

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

First:

Load * Inline [

Month,Value

Jan, 10

Feb, 15

Mar, 20

Apr, 30

May, 20

Jun, 20

Jul, 20

Aug, 20

Sep, 20

Oct, 20

Nov, 20

Dec, 20

];

Second:

Load * Inline [

Month,Value2

Jan, 10

Feb, 20

Mar, 30

];

I am using line chart with two expression. When I use accumulation(or rangesum), the graph is saturated after March month for second expression(sum(Value2). I want to hide the values in the graph. I tried changing the background color and text color, it didnt work. It was working with Straight Table and Bar chart. I have one problem in Line chart, the graph displays till April Month.

For second Expression:

Background color : if(Column(2) =above(sum(Column(1))),White(),green())

Text color : if(Column(2) =above(sum(Column(1))),White(),green())

How to hide the repeated values?

Thanks

Re: Hide repeated values when using accumulation in chart

swuehl — Fri, 17 Jun 2016 08:58:22 GMT

What about doing the check for value already in the expression:

=If(Len(trim(Value2)),Rangesum(Above(Sum(Value2),0,rowno())))

Re: Hide repeated values when using accumulation in chart

Sat, 18 Jun 2016 07:03:11 GMT

Thanks Swuehl. Its working now. .

I used rank function in Background color. if(isnum(rank(below(sum(value2))),white(),green())