topic Re: Chart Design in QlikView

Chart Design

Mon, 09 Jun 2014 11:14:08 GMT

Hi,

I am new to Qlik, I want to create chart.

Can any one suggest?

Re: Chart Design

Gysbert_Wassenaar — Mon, 09 Jun 2014 11:23:57 GMT

You can use a straight table and use minichart representations for the expressions for the bar and line chart columns.

Re: Chart Design

Mon, 09 Jun 2014 11:45:49 GMT

Can you elaborate please?

I made List Box then from that made mini Chart.
But unable to make it horizontal.

Re: Chart Design

Mon, 09 Jun 2014 12:25:05 GMT

You need to create a new chart and then choose straight table.

Add institution as a dimension, create your expressions and for the expressions that you would like to present in minichart, choose mini-chart in the drop-down-box under representation on the expression tab. There can you select many different kind of mini-charts.

Fredrik

Re: Chart Design

Mon, 09 Jun 2014 12:29:29 GMT

Yes I understood that point.
But problem is I am unable to make chart highlighted in Red box.
please see below image

Re: Chart Design

Mon, 09 Jun 2014 12:40:57 GMT

Ok, i understand. I actually think that is a linear gauge representation.

You can download the app in your screenshot from Qlik's demo site. It can be found here:Qlik Demos: See QlikView in Action | Demo.Qlik.Com

Re: Chart Design

Mon, 09 Jun 2014 12:51:18 GMT

I know that Link.
But how to make that chart?
I am using personal Edition, might be this is the reason why I am unable to edit from downloaded .qvw file!

I dont have much detail of Qlik.

Re: Chart Design

Mon, 09 Jun 2014 12:55:43 GMT

Try using a linear gauge instead of a minichart.

See this thread for examples:

Straight Table chart with linear gauge chart

Re: Chart Design

Mon, 09 Jun 2014 12:57:30 GMT

If you make your expression a linear gauge instead of a mini chart, you can achieve a horizontal bar chart look.

Min value = 0

Max value = whatever will contain all of your values

You can adjust the settings to change the appearance.

Re: Chart Design

Mon, 09 Jun 2014 12:58:18 GMT

Ok, i was hoping you could open that app and look at the properties for that specific graph.

So to be able to create that column in the graph with the horizontal bar, start with choosing linear gauge. Then you need to define a min and a max value. Max value usually is the largest Sales amount or something similar. Then its just some fine tunings left to do, like bar color, indicator style.

see attached images.