topic Re: Best Representation According to data. in QlikView

Best Representation According to data.

Fri, 25 Sep 2015 11:55:27 GMT

Hi experts,

I have to show branchwise data in graph. But number of branches is more so that data is not looking readable at a glance. Now I'm using Bar chart, but it is not looking so effective.

Plz suggest some good graph type to present this data.

Re: Best Representation According to data.

arulsettu — Fri, 25 Sep 2015 11:56:52 GMT

post your sample app

Re: Best Representation According to data.

gautik92 — Fri, 25 Sep 2015 11:57:06 GMT

have a look at this

Re: Best Representation According to data.

amit_saini — Fri, 25 Sep 2015 11:58:30 GMT

Larib,

You can restrict data from here and enable a scroll.

Thanks,

Re: Best Representation According to data.

Fri, 25 Sep 2015 12:16:45 GMT

what was the original type of graph that you were using? You also said the bar chart did not look good - is that because there ar too many bars showing at one time? You can tweak it by using Amit's suggestion of determining how many bars you want to show at a time before needing to scroll - along with that you can alos use the Axis tab to show your lables in a diffeernt format, to help display more bars

Re: Best Representation According to data.

jonathandienst — Fri, 25 Sep 2015 12:24:34 GMT

Change the orientation on Properties | Style to horizontal. Its usually easier for users to scroll vertically than horizontally. You can still use the other suggestions above with a horizontal bar chart.

Re: Best Representation According to data.

Fri, 25 Sep 2015 12:28:42 GMT

Consider dimension limits and sort by whatever measure or KPI is important. If you have so many that it is unreadable - chances are you don't need to see all of them in one glance. The user can always click on the "Other" section to see the remaining items.

Re: Best Representation According to data.

Fri, 25 Sep 2015 12:35:00 GMT

there are several options and combinations of options that can be used - can you provide a sample or screenshot of either how the data looks now or what you are trying to achieve

Re: Best Representation According to data.

qlikviewwizard — Sat, 26 Sep 2015 01:49:30 GMT

Hi,

Check this for which chart is best based on the data presentation.