Suitable Chart

[nihhalmca]

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.

[Anonymous]

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.

[nihhalmca]

Hi Bill, Thanks for response.

I will give example:

Dim: Product (It has 1000's products)

Measure: Price

Regards,

Nihhal.

[Anonymous]

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

[Anonymous]

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 ?

[MarcoWedel]

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

[qlikviewwizard]

Hi,

Check this application. Hope this will help you.

[nihhalmca]

Hi Marco, thanks for response.

I want to do without scroll bar.

[raajaswin]

up to my knowledge.. Only this is possible

[MarcoWedel]

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

regards

Marco