Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Hide repeated values when using accumulation in chart

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: hidevalues.png

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

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

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

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

View solution in original post

2 Replies
Highlighted
MVP
MVP

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

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

View solution in original post

Highlighted
Not applicable

Thanks Swuehl. Its working now.  .values.png

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