Continous in charts

[#1]

Hi all,

I have a strange question which i cant seem to figure out.

Let me post some examples:

1: Data from all time - Using continous load to see from start to end date - Thats fine

2: Now i select a Month okt - It shows me data from the first to the 31 - This is also fine

3: Now i select two other months - Now it takes on dates from the other month on both pictures (Notice my blue expression is correct with data, but my avg goes all the way

This is my avg expression:

=avg(aggr(sum(TotalSessions),Date_CleanDato)

And it does the same if i select AVG under trendlines

But i also happens if i dont have any AVG included at all

[qlikpahadi07]

Hi Thomas,

Can't you use a Default QV Avg function for your chart??

Under Expression Tab

[#3]

As i wrote in the buttom, i also tried with that. But its the same result. And the date problem is also a problem if i dont have any AVG 😕

[swuehl · Accepted solution]

The continous axis is sometimes a bit hard to handle, also when you want to show several defined axis points, like dates for the month start). QV takes quite a lot of control over the visuals here.

For your specific issue, you can try setting defined static min / max values for the continuous axis:

=min(Date_CleanDato)

=max(Date_CleanDato)

This usually works for me.

[#5]

Okay, yes it is very strange that it is forcing the dates to be visualized even though they are not represented in the selection.

Why didnt i think of that - Thanks a lot