topic Re: BarChart in QlikView

BarChart

NavinReddy — Thu, 20 Mar 2014 19:16:18 GMT

Dear All,

I want to show Y -Axis doller format

$1,400

$1,200

$1,000

like the format i need to be show how can i do this could you please some one guide me

And Bar width also how can i dicrease

please give me an idea

Thanks In Avance

Niranjan

Re: BarChart

mikecrengland — Thu, 20 Mar 2014 19:49:16 GMT

Hi Niranjan -

Unless something has changed, there's not a good answer. you need to format for money and use Static Min, Max and Step, and then that only works if something is filtered. Once you clear filters, the $ goes away.

Mike

www.fortunecookiebi.com

Re: BarChart

NavinReddy — Thu, 20 Mar 2014 20:01:10 GMT

Hi Mike,

Its not working for me i trying the same way

is there any another way

Regards,

Niranjan

Re: BarChart

mikecrengland — Thu, 20 Mar 2014 20:25:23 GMT

Odd... I just tried it again and it worked. Could you attached your document with some sample data?

Re: BarChart

veidlburkhard — Thu, 20 Mar 2014 20:26:02 GMT

Hi Niru,

i) Money sign: in the 'Number' tab you can define a money sign (dollar) for the y axis. See below an example:

ii) Size of the bars: Go on 'Presentation' tab and adjust the 'Cluster Distance' accordingly. This allows you to arrange the size of your bars:

Hope this helps.

Burkhard

Re: BarChart

NavinReddy — Thu, 20 Mar 2014 20:35:31 GMT

Thank you guys .....

Re: BarChart

NavinReddy — Thu, 20 Mar 2014 20:37:57 GMT

Hi Mike,

How can i dicrease my bar width

Best Regards,

Niranjan

Re: BarChart

mikecrengland — Thu, 20 Mar 2014 20:52:29 GMT

The only way that I know of is like Burkhard mentioned... to increase the cluster distance. The bar width will change with the width of the chart.