topic Re: Gauge Chart in QlikView

Gauge Chart

NavinReddy — Mon, 02 Jun 2014 13:07:18 GMT

Dear All,

I want to show region wise percentage

i am trying to create one chart

like this type but i dont know how to develop

could some one help me to develop this chart

are any Example of QVW also better to understand for me

Thanks In Advance

Niranjan

Re: Gauge Chart

Mon, 02 Jun 2014 13:09:44 GMT

Hi Niru

to show %, just tick "relative" in the properties, tab "expression"

best regards

chris

Re: Gauge Chart

NavinReddy — Mon, 02 Jun 2014 13:16:55 GMT

Hi,

But i am trying create like That Circle chart

Round((
Sum ({< [Hierarchy 2] ={'GWM Operation'},[Hierarchy 2]={'GIM Operation'} >} [Actual Dollars])
/
Sum ({< [Hierarchy 2]=>} [Actual Dollars])
)

I am using this expression,

is there any example for like that circle chart showing percentage

BestRegards,

Niranjan

Re: Gauge Chart

NavinReddy — Mon, 02 Jun 2014 13:28:05 GMT

Guys any Idea...

Re: Gauge Chart

Mon, 02 Jun 2014 13:28:18 GMT

Hi Niru

try this

to display % of sales in region wise, just tick "relative" in the properties, tab "expression"

or else upload u r file.

Regards

Chandan

Re: Gauge Chart

its_anandrjs — Mon, 02 Jun 2014 13:40:58 GMT

You can make this type of charts by the use of the Pie charts and Load a Dimension selection table also

Eg:-

LOAD * Inline

[Year,Sales

2010,45871

2011,34567

2012,34346

2013,56568

2014,453453];

Dim:

LOAD * Inline

[Selection

Numeric

Percentage]

1. Then follow the instructions take pie chart Your dimension here i explain with Dim- Year

2. Then Expression Sum(Sales) and make this expression as relative.

3. Then select style from the properties.

4. And adjust your legend by the pressing ctrl+Shift key and by red lines on the chart make legend in the centre of the chart.

See the attached sample snap

And add the list box Selection below the chart

Re: Gauge Chart

maxgro — Mon, 02 Jun 2014 13:43:15 GMT

see attachment

Re: Gauge Chart

NavinReddy — Mon, 02 Jun 2014 14:20:32 GMT

Thank you so much guys

always you community guys are rock ..