Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem with "static min" and "static max"

Good day,

I want to make a graph that displays the absences of person on a time line.

I have a table with :
- id of the absence
- person
- start date
- end date

To aim this, I use a bar chart stacked.

My dimensions are :
- Person
- ID of the absence

My expression is


[End date] - [Start date]


To have the correct space between 2 stacked bars, I use the bar offset :


if(
isnull(above([End date])),
0,
[Start date] - above([End date]))


error loading image

To accomplish what I want, I supposed that I needed to set the first offset to "[Start date]" and change the "static min" and "static max" to "min([Start date])" and "max([End date])".

Unfortunately, the "static min" and "static max" don't behave like I thought...

If I look my values between 40 and 80, I see this :

error loading image

- 1 value near 45 for Bob
- 1 value near 60 for Bob
- 1 value near 70 for Toto

So, if I set "static min = 40", "static max = 80", I thought I would have a zoom on this part of the graph.

Here is what I have :

error loading image

- 1 value near 52 for Bob
- 1 value near 68 for Bob
- nothing for Toto

Why is there a such difference ?

Can anyone tell me what I've done wrong ?

0 Replies