Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

how to make a chart like this

Hi all:

         I have a problem that I need a chart like below in qlikview with data in the attachment.

Could anyone help me to get it?

ps:  maybe need drill down with field Area. ( like city ,etc )

1 Solution

Accepted Solutions
effinty2112
Honored Contributor

Re: how to make a chart like this

Hi there,

You can create a straight table with an expression like below:

1.bmp

In the chart properties choose Linear Gauge as the Display Option Representation

2.bmp

Set up the gauge properties like this:

3.bmp

Set the background colour to ARGB(64,128,128,128):

4.bmp

25 Replies

Re: how to make a chart like this

HI,

There is no chart which will give you both combination, but here is the work around.

Regards,

Kaushik Solanki

Re: how to make a chart like this

How about this?

Capture.PNG

Life is so rich, and we need to respect to the life !!!
qlikviewnovice
Valued Contributor II

Re: how to make a chart like this

Hi

You have to create separate Chart and Text boxes to achieve your expected output.

Employee
Employee

Re: how to make a chart like this

Maybe this?

Capturar.PNG

Re: how to make a chart like this

Interesting, Can i know after that do we require to change any setting to get the values. Because, i am not getting any values.

Can you please explain me this

dual(Only( [2014 Score]),2)

Life is so rich, and we need to respect to the life !!!
Employee
Employee

Re: how to make a chart like this

dual(Only( [2014 Score]),2)

this will plot a bar with size = 2 and shows the value [2014 Score]


It´s a workaround when you want to create a fixed bar showing a value


Dual ‒ QlikView

effinty2112
Honored Contributor

Re: how to make a chart like this

Hi there,

You can create a straight table with an expression like below:

1.bmp

In the chart properties choose Linear Gauge as the Display Option Representation

2.bmp

Set up the gauge properties like this:

3.bmp

Set the background colour to ARGB(64,128,128,128):

4.bmp

Re: how to make a chart like this

Got It, But still values not generated. For third expression i use the Offset = 1, Values are generated.

Life is so rich, and we need to respect to the life !!!
Employee
Employee

Re: how to make a chart like this

If you attach your qvw I can take a look and help you

Community Browser