topic Re: How to split dimention in two graph in QlikView

How to split dimention in two graph

stekol61 — Thu, 31 Mar 2016 07:54:48 GMT

Hi!

In my enclosed qvw I want to select Country, e.g. SE, and in the two graphs show the "Memory Usage" for each node in SE.

So by selecting SE i want graph1 to show "Memory Usage" for Host "FRE2P" and graph2 to show "Memory Usage" for "HY2P"

How can this be done?

/Stefan

Re: How to split dimention in two graph

sunny_talwar — Thu, 31 Mar 2016 10:27:24 GMT

What happens when you select DK or All? Is this only for when you select SE?

Re: How to split dimention in two graph

johanlindell — Thu, 31 Mar 2016 10:38:33 GMT

Hi Stefan.

I would use a Trellis chart. See atatached.

To be sure you get correct data, you should try to get rid of the synthetic keys.

Brgds

Johan

Re: How to split dimention in two graph

stekol61 — Thu, 31 Mar 2016 11:24:31 GMT

Hi!

Terellis char works OK.

However,it doesn't seems to be possible to enable x-axis scrollbar.

Is there a way to solve this?

/Stefan

Re: How to split dimention in two graph

johanlindell — Thu, 31 Mar 2016 16:06:04 GMT

It does not seem to work. I don't know why.

What you can do, if not all parts of the lines shows up, is to open the chart properties, go to the "General" tab, switch to "Bar Chart", go to the "Presentation" tab, select "Allow Thin Bars" and "Show All Bars" and finally go back to the "General" tab and switch back to Line chart. Then the full line should show up.

By the way - you can change the number of columns and rows of charts in the Trellis chart, You'll find the settings in the Dimension tab under the button "Trellis..."

/Johan

Re: How to split dimention in two graph

stekol61 — Fri, 01 Apr 2016 08:05:08 GMT

Hi!

The problem is that the graphs are updated with new dates every day and after some time there will be so many dates on the x-axis that you will not be able separate dates from each other. (not sure how Qlik handles this?)

With the x-axis scrollbar you could limit the number of dates seen in the graph to e.g. 10.

Maybe this is not possible when using Trellis graphs.

/Stefan

Re: How to split dimention in two graph

johanlindell — Fri, 01 Apr 2016 08:41:08 GMT

Hi Stefan,

A workaround: You can always limit the selection instead. See attached where if you have selected "Date" in the dimension group, you will see the last 10 days. If you select a date you will see the last 10 days up to that date.

Johan