topic Re: Creating Bar chart And Trend-Line chart on QlikView in QlikView

Creating Bar chart And Trend-Line chart on QlikView

Mon, 17 Jun 2013 08:01:52 GMT

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

How can i create bar chart with single color format?
How to create trend line chart on same bar chart but with different input?
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?
How to use JSON file data to draw bar chart and trend lines chart?

Thanks,

Thiru

Re: Creating Bar chart And Trend-Line chart on QlikView

sujeetsingh — Mon, 17 Jun 2013 08:12:15 GMT

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!!

Re: Creating Bar chart And Trend-Line chart on QlikView

Mon, 17 Jun 2013 09:14:52 GMT

Hi,

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

Re: Creating Bar chart And Trend-Line chart on QlikView

sujeetsingh — Mon, 17 Jun 2013 09:30:15 GMT

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