how to make a chart like this

[#1]

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 )

[kaushiknsolanki]

HI,

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

Regards,

Kaushik Solanki

[Anil_Babu_Samineni]

How about this?

[Anonymous]

Hi

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

[Clever_Anjos]

Maybe this?

[Anil_Babu_Samineni]

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)

[Clever_Anjos]

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 · Accepted solution]

Hi there,

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

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

Set up the gauge properties like this:

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

[Anil_Babu_Samineni]

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

[Clever_Anjos]

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