Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

NavinReddy
Contributor II

BarChart

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

barchart.png

7 Replies
mikecrengland
Contributor III

Re: BarChart

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

NavinReddy
Contributor II

Re: BarChart

Hi Mike,

Its not working for me i trying the same way

is there any another way

Regards,

Niranjan

mikecrengland
Contributor III

Re: BarChart

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

veidlburkhard
Contributor III

Re: BarChart

Hi Niru,

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

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:

Dollar2.jpg

Hope this helps.

Burkhard

NavinReddy
Contributor II

Re: BarChart

Thank you guys .....

NavinReddy
Contributor II

Re: BarChart

Hi Mike,

How can i dicrease my bar width

Best Regards,

Niranjan

mikecrengland
Contributor III

Re: BarChart

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.