Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

gauge chart to show percentages

Hi All

I want to show the data in a different way some thing like this

i have the percentage values as below and i'm using the expression

=sum(aggr( sum(ter)))/sum(aggr( sum(Distinct ter)))*100   where ter is the value on which i'm calculating the totals and percentages

can some one explain with sample data

   

month%age
jan12
feb45
mar65
apr72
13 Replies
Highlighted
MVP
MVP

For an example you can open "Data Visualization.qvw" in your Qlik installation folder,

C:\Program Files\QlikView\Examples\Documents, tab KPI

1.png

Highlighted
Creator III
Creator III

Are you looking for something like this,

B.PNG

If so refer the attached QVW.

Let me know if more info is needed.

Regards

Harish

Highlighted
Not applicable

Hi harish can i have the testtube charts i have 5 months values of percentages to display i will go for 5 test tubes is it possible can u pls help me out with a qvw which u prepared

Highlighted
Creator III
Creator III

I don't think this is possible.

Regards

Harish

Highlighted
Not applicable

I have percentage for a month is that possible to create testtube chart

And i'm calculating sum of a value can i create test tube in this case

Expression is sum (sales)

Highlighted
Creator III
Creator III

You won't be able to see separate test tubes for each month.

You may have to create separate objects for each month.

Regards

Harish

Highlighted
Not applicable

yes i can create i will create

i'm using the below expresiion with no dimension

=sum(aggr( sum(ter),field,Month))/sum(aggr( sum({<IsRolling6={'1'}>}Distinct Ter),k,Month))*100

and getting output as

can you please help me out

Highlighted
Master
Master

Hi John,

for the sake of clarity check this:

Rounding Errors

it is very useful, if you want to Show your numbers with gauges.

i hope that can resolve or improve your issue

beck

Highlighted
Creator III
Creator III

you may have to create objects as shown in the attached QVW.

Regards

Harish