topic Re: Bar Chart Scrolling help in QlikView

Bar Chart Scrolling help

ajaykumar1 — Tue, 23 Sep 2014 06:49:30 GMT

Hi All,

1. I have 2 fields like Outside and inside.I had taken the two fields as dimension and one expression.

As per the attached attached image if am scrolling down the OUTSIDE then INSIDE(from left side) also need to scroll down.

2.I need to avoid the overlapping of the percentage in pie chart as per the attachment.

Please help the same and let me know if need any clarity.

Thanks,

Ajay

Re: Bar Chart Scrolling help

amit_saini — Tue, 23 Sep 2014 06:54:27 GMT

Ajay,

Go through attachment and check Relationship tab.

Thanks,

Re: Bar Chart Scrolling help

ashfaq_haseeb — Tue, 23 Sep 2014 06:56:41 GMT

Hi,

for pie its not supported.

for bar go to chart properties --> Presentation tab --> Click on enable x-Axis scroll.

Regards

ASHFAQ

Re: Bar Chart Scrolling help

avinashelite — Tue, 23 Sep 2014 07:01:12 GMT

Hi Ajay,

For Pie chart to avoid the overlapping, you need to re-size the Pie chart.

For the Bar chart > Go to Presentation tab and set the number of scroll items

Re: Bar Chart Scrolling help

jagan — Tue, 23 Sep 2014 07:09:01 GMT

Hi Ajay,

For scroll bar to Barchart try like below

Chart Properties-> Presentation -> Select Enable X-Axis Scrollbar option

and for Pie chart

if you have many slices then it is different to plot the numbers, one option is to show numbers in Legend like

Chart Properties-> Presentation -> Select Show Legend & Show Numbers in Legend option

or try Pie Popout

Chart Properties-> Expression-> click on Expression and give 0.1 for Pie Popout.

Hope this helps you.

Regards,

Jagan.

Re: Bar Chart Scrolling help

ajaykumar1 — Tue, 23 Sep 2014 07:13:37 GMT

Thanks Amit and Ashfaq.

Ashfaq---Already One dimension is enable for scrolling(i.e Right side one OUTSIDE).But when am scrolling down that OUTSIDE one INSIDE(left side) has to scroll.But thats not working.

I hope only one scroll allowed ..right

Ajay

Re: Bar Chart Scrolling help

ashfaq_haseeb — Tue, 23 Sep 2014 07:14:41 GMT

I think

Can you post a sample to look over

regards

ASHFAQ

Re: Bar Chart Scrolling help

ashfaq_haseeb — Tue, 23 Sep 2014 07:16:22 GMT

Hi,

I checked if you have two dimensions only i scroll is allowed.

Regards

ASHFAQ

Re: Bar Chart Scrolling help

ajaykumar1 — Tue, 23 Sep 2014 07:18:53 GMT

Yes...So it seems my case whether ISSIDE or OUTSIDE only one dimension we can scroll...right.

Bad luck 🙂

Thanks,

Ajay

Re: Bar Chart Scrolling help

ashfaq_haseeb — Tue, 23 Sep 2014 07:21:26 GMT

Yes,

Only 1st dimension is scrolable.

If you want the other to be scroll. Go to dimension tab and promote the second dimension to be first.

regards

ASHFAQ

Re: Bar Chart Scrolling help

ajaykumar1 — Tue, 23 Sep 2014 07:51:50 GMT

Thanks to all for clarity.But i can make only one correct answer

Ajay