Creating Bar chart And Trend-Line chart on QlikView

[#1]

Hi Friends,

I am new to QlikView. I have created a simple bar chart based on the input from excel sheet. Followings are  some of the common question that i have on creating this chart. Please help me out

1. How can i create bar chart with single color format?
2. How to create trend line chart on same bar chart but with different input?
3. By default Qlikview using multiple color for bars. For example, if i have 10 - bars then i can see ten colors. How to avoid this?
4. How to use JSON file data to draw bar chart and trend lines chart?

Thanks,

Thiru

[sujeetsingh]

Hi.

you can create bar chart of single color by going to Color and then setting it for required one.

--Add reference line option on expression tab and then assign it the input you want.

--JSON?? i did not get it.

Hope it help!!

[#3]

Hi,

Thanks . JSON is the data format. Like CSV file format  And one more how could we increase the width of the bar?

[sujeetsingh]

I did not find any hard and fast way of doing it

-----you can do it by reducing the width of complete chart

---- press Ctrl+Shift  and then reduce the size of bar layout of the chart in this case the chart size remains same.

If you are able to get any help from this thread then please mark it with Answered or Helpful Answer which is applicable.

Thanks