Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
guilherme_hn
Partner - Contributor II
Partner - Contributor II

How to create a HC curve line?

Hello Qommunity !

 

I've tried to do a chart to show to growth of my company and I'm not able to do all I want.
Here it is.

img1.png

The problem is when i filter some year. I want to show the number of employee that started the year and ended year.
2018 started with 1190 and ended with 1703 employees, but in the chart show like this:

img2.png

How can I fix that? 

Here is the set statement that I'm using:


RangeSum(Above(count(distinct[ASSOCIATE ID-ID]), 0, RowNo()))-
RangeSum(Above(count(distinct [Id Global Desligado]), 0, RowNo()))

Appreciate!

2 Replies
Channa
Specialist III
Specialist III

=sum (  {<Year =  >}  TotalSuggestions)

 

 

try to exclude year selection use expression like this

Channa
Channa
Specialist III
Specialist III

may be you have master drill item , if you select year it is showing month, avoid drill
Channa