topic Re: Problem with Bar Chart visualization. in QlikView

Problem with Bar Chart visualization.

Anonymous — Mon, 11 Aug 2014 07:12:42 GMT

Hi All,

I have designed a 100% bar chart (Please see Image1).

The issue I'm having is I'm not able to see the values for the yellow bars when I select certain filters.

(Please see Image2).

Basically the percenage axes becomes huge when certain filters are selected.

I tried adjusting the text format to in expressions to make the font smaller to make it visible but its not working for some reason.

Kindly have a look and let me know if I can do something.

Regards

Padmashri.

amit_saini — Mon, 11 Aug 2014 07:18:27 GMT

Padmashri,

Could you please share your application.

Thanks,
AS

engishfaque — Mon, 11 Aug 2014 07:35:54 GMT

Dear Padmashri,

Please Checked to "Relative" check box, which is present in your images "settings1.PNG.png" and "settings2.PNG.png".

Kind regards,

Ishfaque Ahmed

Anonymous — Mon, 11 Aug 2014 07:40:01 GMT

Thanks Ishfaque. It worked.

DavidFoster1 — Mon, 11 Aug 2014 07:42:15 GMT

Can you explain what the number in the yellow represents and what each row represents?

Also, have you considered using a straight table and a linear gauge for this kind of presentation (especially if seeing the numbers is critical)?

Anonymous — Mon, 11 Aug 2014 07:46:46 GMT

Hi David,

The yellow in each Bar represents the gap to forecast.

Each bar represents the various product groups and the blue is actuals achieved and yellow is the gap to forecast.

My customer is particular about having bar charts.

Anonymous — Mon, 11 Aug 2014 08:53:04 GMT

Exploring Linear Gauge now. Thanks!