topic Re: Suitable Chart in QlikView

Suitable Chart

nihhalmca — Sun, 18 Oct 2015 09:46:28 GMT

Hi All,

Which chart is suitable to display thousands of records without scroll bar. For example

Dim: Product (It has 1000's products)

Measure: Price

Thanks,

Nihhal.

Re: Suitable Chart

Anonymous — Sun, 18 Oct 2015 09:55:47 GMT

Depends on your data and what you wish to achieve, but if it has a date based Dimension I'd probably start with a Line Chart.

Re: Suitable Chart

nihhalmca — Sun, 18 Oct 2015 10:06:29 GMT

Hi Bill, Thanks for response.

I will give example:

Dim: Product (It has 1000's products)

Measure: Price

Regards,

Nihhal.

Re: Suitable Chart

Anonymous — Sun, 18 Oct 2015 10:13:24 GMT

Hi Nihhal,

Its based on dimensions(Date,Product Types) and You Will have a good view on Line and Single dimension bar combo.

Thanks,

Bunny

Re: Suitable Chart

Anonymous — Sun, 18 Oct 2015 10:13:37 GMT

With a dimension of Products you will not be able to display thousands of them on one screen without a scroll bar, even if you have very, very big screen.

Are the products grouped in some way so you could use some kind of drill down ?

Re: Suitable Chart

MarcoWedel — Sun, 18 Oct 2015 22:38:46 GMT

Hi,

to be able to switch to continuous dimension axis while having non-numerical Product values you could try with a calculated dimension like

FieldIndex('Product', Product)

and extend to

Dual(Product, FieldIndex('Product', Product))

to still get the Product text value.

One example could be:

But as this chart is rather impossible to read for specific products, you could try to display aggregated Price values e.g. in some sort of histogram:

hope this helps

regards

Marco

Re: Suitable Chart

qlikviewwizard — Mon, 19 Oct 2015 01:50:35 GMT

Hi,

Check this application. Hope this will help you.

Re: Suitable Chart

nihhalmca — Tue, 20 Oct 2015 09:01:29 GMT

Hi Marco, thanks for response.

I want to do without scroll bar.

Re: Suitable Chart

raajaswin — Tue, 20 Oct 2015 13:48:50 GMT

up to my knowledge.. Only this is possible

Re: Suitable Chart

MarcoWedel — Wed, 21 Oct 2015 21:06:03 GMT

The last of the 3 charts in my example has not scroll bar.

regards

Marco