topic Whats the best Chart to use........ in QlikView

Whats the best Chart to use........

Thu, 23 Feb 2012 10:14:39 GMT

Hi,

What is the best Chart to use for the following requirements:

A line graph is required to display two dimensions 'date' and 'site'

3 different expressions are also required to be displayed, act. avg. target.

Thanks,

Gregg

Whats the best Chart to use........

vijay_iitkgp — Thu, 23 Feb 2012 10:50:07 GMT

I think best chart should be line chart with only one dimension at a time. You can use cyclic drill for Date and Site

Whats the best Chart to use........

Thu, 23 Feb 2012 10:54:24 GMT

Hi Vijay,

By using thecyclic drill would this mean that only the site OR date are visible at the one time?

I need both to be visible.

Regards,

Gregg

Re: Whats the best Chart to use........

matt_crowther — Thu, 23 Feb 2012 11:27:29 GMT

Gregg,

Bit of a tricky one as Line Charts in Qlikview don't split out as they should unlike Bar Charts:

The nearest you can get with a Line Chart is to Trellis it - Using 'Site' and maintain Date as the dimension shown in the actual chart, you can then add as many Expressions as reuqired as below:

Hope that's of use. NB: it can take a little adjustment to get the Trellis settings to work properly.

All the best,

Matt - Visual Analytics Ltd

Qlikview Design Blog: http://QVDesign.wordpress.com

@QlikviewBI

Whats the best Chart to use........

Thu, 23 Feb 2012 11:55:58 GMT

Hi Matthew,

Thanks for that.

I will work on this.

Is there a way to make both graphs bigger on screen when they are split out?

Thanks,

Gregg

Re: Whats the best Chart to use........

matt_crowther — Thu, 23 Feb 2012 12:12:52 GMT

Gregg,

For some reason Trellis Charts set to really stupid sizings.

I find that if you have a fairly static 'Trellis Dimension' (in your case site) then you can fix the number of rows and columns under Dimension > Trellis Settings - in my example it's 3 colums and a single row.

This does cause problems if you allow users to select across your Trellis dimension as it can throw the display out of sync.

All the best,

Matt - Visual Analytics Ltd

Qlikview Design Blog: http://QVDesign.wordpress.com

@QlikviewBI