Discussion Board for collaboration on QlikView Layout & Visualizations.
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 )
Go to Solution.
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):
There is no chart which will give you both combination, but here is the work around.
How about this?
You have to create separate Chart and Text boxes to achieve your expected output.
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)
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
Got It, But still values not generated. For third expression i use the Offset = 1, Values are generated.
If you attach your qvw I can take a look and help you