topic Re: Continous in charts in QlikView

Continous in charts

Sat, 14 Dec 2013 23:22:18 GMT

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

Re: Continous in charts

qlikpahadi07 — Sun, 15 Dec 2013 04:57:40 GMT

Hi Thomas,

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

Under Expression Tab

Re: Continous in charts

Sun, 15 Dec 2013 09:02:14 GMT

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 😕

Re: Continous in charts

swuehl — Sun, 15 Dec 2013 09:26:52 GMT

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.

Re: Continous in charts

Sun, 15 Dec 2013 09:33:53 GMT

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