topic Re: Need Help Guys in QlikView

% in gauge chart

divianjani — Wed, 29 Apr 2015 06:58:50 GMT

Hi Everybody,

i have dimension as sales office and metric as Revenue, how ever I need to create a gauge chart for that?

how i need to display sales ofc wise revenue amount % in gauge chart?

I hope anybody can help me

Thanks & Regards

Anjani

Re: Need Help Guys

arulsettu — Wed, 29 Apr 2015 07:09:23 GMT

hi,

can u post sample data source

Re: Need Help Guys

Anonymous — Wed, 29 Apr 2015 07:10:10 GMT

first of all do you really need gauge chart in your scenario ...i think you can use pie chart or bar chart

gauge chart dose not use dimension ... only expression you need to provide..

Thanks

BKC

Re: Need Help Guys

petter — Wed, 29 Apr 2015 07:10:16 GMT

Use TOOLS (menu) and select Quick Chart Wizard (menu choice on drop-down menu).

Then select NEXT and select GAUGE CHART .... it will guide you through it....

Re: Need Help Guys

divianjani — Wed, 29 Apr 2015 07:12:44 GMT

your reply is fine, however my requirement is I need to show them into gauge chart only

Re: Need Help Guys

divianjani — Wed, 29 Apr 2015 07:17:51 GMT

for ex:

Dim_Sales Ofc
anx
bbd
ccc

Met_Revenue Amount
2500

3500

4500

I need to show the %(percentage) of Revenue Amount for Sales ofc by using gauge chart ,

Re: Need Help Guys

arulsettu — Wed, 29 Apr 2015 07:20:05 GMT

are u sure u need gauge chart. because gauge chart dont need dimensions

Re: Need Help Guys

Anonymous — Wed, 29 Apr 2015 07:23:59 GMT

then you can use sum(Revenue)/sum(Total Revenue) in your expression and give then a list box (sales office filter)

so that they can select the sales office which they want to see the revenue.

Thanks

BKC

Re: Need Help Guys

arulsettu — Wed, 29 Apr 2015 07:27:28 GMT

like this?

Re: Need Help Guys

divianjani — Wed, 29 Apr 2015 07:27:34 GMT

hi , thanks for your reply
I show them like this , but its not giving correct %
top(max(aggr(sum([Total Margin])/sum(TOTAL [Total Margin]),[Inventory.Sales Office Number])))

Re: Need Help Guys

Anonymous — Wed, 29 Apr 2015 07:31:04 GMT

can you post a sample application and your required output.

Thanks

BKC

Re: Need Help Guys

divianjani — Wed, 29 Apr 2015 07:59:14 GMT

thanks but sorry, don't have sample application from required output.

give me your mail id ?

Re: Need Help Guys

Anonymous — Wed, 29 Apr 2015 08:13:11 GMT

balkumarchandel@yahoo.co.in

Re: Need Help Guys

Wed, 29 Apr 2015 09:29:48 GMT

Hi Anjali

It can be possible please see below steps and let see how it goes with you issue

1. Go to Tools

2. Quick Chart Wizard where you will find the different screen by clicking Next you go further and see attached screen.

3. Step 3 you have to define the expression (Sum/Aver/Count etc.)

4. finally you have to select the No of segment or indicator mode etc..

Thanks

Re: Need Help Guys

Anonymous — Wed, 29 Apr 2015 12:27:41 GMT

Hi,

Did you enabled option "Show in Percent %" under Number tab

-Jay

Re: Need Help Guys

Wed, 29 Apr 2015 13:44:17 GMT

Hi check out the Pie Gauge Chart by stephen.redmond‌ :

https://community.qlikview.com/docs/DOC-5615

Re: Need Help Guys

Thu, 30 Apr 2015 03:40:01 GMT

Hi Anjani,

Go to the properties-> select presentation tab-> and select percentage.

Rgds.

Priyantha.