topic Combining two graphs in QlikView

Combining two graphs

Mon, 17 Feb 2014 09:22:47 GMT

Hi,

Basically I want to combine the following two graphs, in the way that the average values are in the background of the time series' absolute values (that the absolute value of a month can easily be compared to its historical average, so graph 1 is repeated 6 times in the background of graph 2).

Dimension = Month

Expression =Avg({1}$(Heat))

First dimension = Year

Second dimension = Month

Expression = Heat

I tried set analisys and TOTAL, but i couldn't figure it out. Is there a way?

Re: Combining two graphs

MK_QSL — Mon, 17 Feb 2014 09:41:37 GMT

Use combo chart...

Re: Combining two graphs

Mon, 17 Feb 2014 09:57:47 GMT

Combining the types of graphs isn't my problem, combining the two different dimensions of the graphs (month, and Year & Month) is my problem.

Re: Combining two graphs

MK_QSL — Mon, 17 Feb 2014 09:58:54 GMT

Can you load your sample apps or excel file?

Re: Re: Combining two graphs

Mon, 17 Feb 2014 10:05:46 GMT

The excel in the attachment.

Re: Re: Re: Combining two graphs

Christian_Lauritzen — Mon, 17 Feb 2014 15:17:26 GMT

Hi Willem,

I attached a working solution, where I pre-calculated the average in the script. There is one issue however - I needed to reduce number dimensions to only one as there seems to be an issues with line graphs and two dimensions;

If I use two dimensions, Year first, this is the result:

I have noticed previously that lines in combination with several dimensions behave very strangely. Even stranger is that two dimensions work if I swap the Year and Month dimension:

Hope this will help you. I have attached the file.

/Christian

Re: Combining two graphs

Tue, 18 Feb 2014 08:19:21 GMT

Thanks Christian. Looks allright! I'm going to have a go at this.

I, too, noticed the strange behaviour of the two dimensions. Should we report this?

Re: Combining two graphs

Christian_Lauritzen — Tue, 18 Feb 2014 10:39:36 GMT

I am glad to hear I could help you! Thanks.

I am not sure it is worthwhile reporting the issue. It has been around for a long time, and I am sure they are aware of it. There are after all workarounds, so it is not critical. Now, with Qlikview Next around the corner, I would guess Qlik will spend very little resources for fixing minor bugs in this release.

/Christian