topic Re: Pie chart (range of values) in QlikView

Pie chart (range of values)

Fri, 31 Jan 2014 10:02:47 GMT

Can any one help, how to prepare this chart

Thanks in advance,

Pavan.

Re: Pie chart (range of values)

Fri, 31 Jan 2014 10:06:42 GMT

Create a Pie Chart whit a Valuelist in dimension

Valuelist('>0 & 0.92','0.92 & 0,92',....)

and a conditional background color for expression...

Re: Pie chart (range of values)

maxgro — Fri, 31 Jan 2014 10:18:08 GMT

hope it helps you

Class() with different sizes

Re: Pie chart (range of values)

Fri, 31 Jan 2014 10:25:20 GMT

Can u please tell me in-detail, what to do and how to do.

Re: Pie chart (range of values)

Fri, 31 Jan 2014 10:42:41 GMT

look at the attacched example

Hope this helps

Re: Pie chart (range of values)

Fri, 31 Jan 2014 11:04:07 GMT

I'm sorry, I can not access qvw file.

I'm using personal edition.

Please post the procedure to be done.

Thanks in Advance,

Pavan.

Re: Re: Pie chart (range of values)

Fri, 31 Jan 2014 11:11:57 GMT

In the load script i have this:

Test_Temp:

LOAD * INLINE [

ID, COMP

1, "0,4"

2, "0,5"

3, "0,92"

4, 1

5, "0,99"

6, "1,2"

7, "1,3"

8, "1,95"

9, "1,9"

10, "0,4"

11, "0,5"

12, "0,92"

13, 1

14, "0,99"

15, "1,2"

16, "1,3"

17, 1

18, "0,99"

19, "1,2"

20, "1,3"

21, 1

22, "0,99"

23, "1,2"

24, "1,3"

25, 1

26, "0,99"

27, "1,2"

28, "1,3"

];

Test:
LOAD *,
if(COMP>0 and COMP<0.92,'>0 & <0.92',
  if(COMP=0.92,'0.92 & 0.92',
  if(COMP>0.92 and COMP<=1,'>0.92 & <=1',  
  if(COMP>1 and COMP<=1.25,'>1 & <=1.25',  
  if(COMP>1.25 and COMP<2,'>1.25 & <2'    
))))) as CUSTOM
Resident Test_Temp;
DROP Table Test_Temp;

And after reload it, create a pie chart with CUSTOM as Dimension,

and

num(sum(COMP)/sum(TOTAL COMP) ,'#.##0%')

as Expression.

Hope this helps

Re: Pie chart (range of values)

Fri, 31 Jan 2014 11:20:59 GMT

Thank you very much.....

Really Great Boss.......

Thanks......

Re: Pie chart (range of values)

Fri, 31 Jan 2014 11:27:47 GMT

Hi,

Can u please tell me what is the chart type, I tried it on combo chart, but i don't know how to get a thin line instead of bar.

How to get the word "Age (Years)".

Thanks in Advance,

Pavan.

Re: Pie chart (range of values)

Fri, 31 Jan 2014 11:33:59 GMT

It's a line chart with Squares Symbol on Expression and whit label of dimension like 'Aged (Years)' and with the orientation in Style tab on orizontal chart.

Re: Pie chart (range of values)

Fri, 31 Jan 2014 11:37:59 GMT

Or whit a line chart with Squares Symbol on Expression and whit a like 'Aged (Years)' and with a text in Chart(presentation tab) like ='Age (Years)'

Re: Pie chart (range of values)

Fri, 31 Jan 2014 12:19:17 GMT

HI,

As u said, I have take a line chart, with square as symbols.

But I didn't get the straight black thin line on the chart how to make that ?

If u have any idea, please let me know.

Thanks & Regards,

Pavan.

Re: Pie chart (range of values)

Fri, 31 Jan 2014 13:50:09 GMT

try to enable two 'Show Grid' flags in Axes tab of chart...