topic Re: Need pie chart help - gap between pie chart regions in QlikView

Need pie chart help - gap between pie chart regions

ananyaghosh — Sat, 18 Apr 2015 05:45:53 GMT

Hi,

Can U tell me how to increase the space/gap between different regions in pie chart?

I have attached a screen shot of my pi chart and also I have couple of questions out there. Please give me suggestions on that questions.

Thanks,

Sandip

Re: Need pie chart help - gap between pie chart regions

robert_mika — Sat, 18 Apr 2015 05:59:09 GMT

Look here:

Reposition Pie Chart data point values?

Re: Need pie chart help - gap between pie chart regions

neha_shirsath — Sat, 18 Apr 2015 06:52:01 GMT

Hi Sandip,

Go to expression and expand + sign and in that go to Pie popout option and write your expression there.

See the below image-

Regards,

Neha S.

Re: Need pie chart help - gap between pie chart regions

ananyaghosh — Sat, 18 Apr 2015 07:22:22 GMT

Hi,

It works, but I want this in below screen shot:

Please give me a screenshot - how to do legend with data.

Re: Need pie chart help - gap between pie chart regions

neha_shirsath — Sat, 18 Apr 2015 07:35:50 GMT

Hi Sandip,

I think it is not possible you can only show values.

And any how on right hand side legend showing the colour and its description.

Regards,

Neha S.

Re: Need pie chart help - gap between pie chart regions

fred_s — Sat, 18 Apr 2015 16:06:52 GMT

Hi Sandip,

Looks like it's possible, but there's a difference in the result.

Legend: A is 15% and

Text as Popup: A 20%.

If you can figure out why there's a difference, your problem is solved 😉

Grtz Fred

Re: Need pie chart help - gap between pie chart regions

fred_s — Sat, 18 Apr 2015 16:12:29 GMT

Sorry, Text as Popup was showing my values instead of % .. duhhh

This one was better:

=Letter & ' ' & num(sum(Number) / Sum(TOTAL Number) , '#0%')

See attachment.

Grtz Fred

Re: Need pie chart help - gap between pie chart regions

fred_s — Sat, 18 Apr 2015 16:22:24 GMT

I love it myself 🙂

This one is without "Show Legend" on the presentation properties.

Re: Need pie chart help - gap between pie chart regions

ananyaghosh — Sat, 18 Apr 2015 18:44:36 GMT

Hi,

So you want to say that I have to add a second expression in the chart?

I have added a second expression as

=[Property Type] & '-' & Count([Property Type]) & '%'

and the chart is showing as below. But I want that values on data point will come like this: Office - [36%], Land - [34%]

and I have used first expression as 'Count([Property Type])'

Thanks,

Sandip Ghosh

Re: Need pie chart help - gap between pie chart regions

fred_s — Sat, 18 Apr 2015 18:57:59 GMT

Do you have a Qlikview license / is it possible for you to view my file?

My first expression: =sum(Myvalue)

Values on datapoints and Text as Popup, unchecked

My second expression: =Mydim & ' ' & num(sum(Myvalue) / Sum(TOTAL Myvalue) , '#0%')

Values on datapoints and Text as Popup, checked

Re: Need pie chart help - gap between pie chart regions

ananyaghosh — Sun, 19 Apr 2015 07:00:28 GMT

hi,

I have a table like this:

[Property]:

load * inline [

Property Name

Land

Assembly/Meeting Place

Land

Agricultural

Healthcare

Industrial

Sport & Entertainment

Assembly/Meeting Place

Agricultural

Healthcare

Assembly/Meeting Place

Sport & Entertainment

Land

Assembly/Meeting Place

Multi-Family

Healthcare

Sport & Entertainment

Healthcare

Assembly/Meeting Place

Agricultural

Healthcare

Office

Land

Sport & Entertainment

Retail-Commercial

Assembly/Meeting Place

Land

Lodging and hospitality

Healthcare

Lodging and hospitality

Self-Storage/Mini-storage

Lodging and hospitality

Special Purpose

Single-Family

Special Purpose

Lodging and hospitality

Agricultural

Special Purpose

];

Now I want to show different property type percentage among total property type. So Suppose 'Land' type is 4 times used among 56 times in property type data. So In the pie chart I want show Land [ 4% ] in data values in pie chart.So below is the picture of that:

I have used count([Property Name]) in first expression and Values on data points and Text as Popup, unchecked.

and have used =[Property Name] & ' - ' & num(count([Property Name])/Count(total [Property Name]), '##.##%')

as second expression and Values on data points and Text as Popup, checked.

So as a correct value should show for Land property type should show as Land [.25%] - when Land property type is appear 4 times among all property type.

So, please suggest what to do now.

Thanks,

Sandip

Re: Need pie chart help - gap between pie chart regions

ananyaghosh — Sun, 19 Apr 2015 07:44:56 GMT

hi,

I have a table like this:

[Property]:

load * inline [

Property Name

Land

Assembly/Meeting Place

Land

Agricultural

Healthcare

Industrial

Sport & Entertainment

Assembly/Meeting Place

Agricultural

Healthcare

Assembly/Meeting Place

Sport & Entertainment

Land

Assembly/Meeting Place

Multi-Family

Healthcare

Sport & Entertainment

Healthcare

Assembly/Meeting Place

Agricultural

Healthcare

Office

Land

Sport & Entertainment

Retail-Commercial

Assembly/Meeting Place

Land

Lodging and hospitality

Healthcare

Lodging and hospitality

Self-Storage/Mini-storage

Lodging and hospitality

Special Purpose

Single-Family

Special Purpose

Lodging and hospitality

Agricultural

Special Purpose

];

I have used count([Property Name]) in first expression and Values on data points and Text as Popup, unchecked.

and have used =[Property Name] & ' - ' & num(count([Property Name])/Count(total [Property Name]), '##.##%')

as second expression and Values on data points and Text as Popup, checked.

So as a correct value should show for Land property type should show as Land [.25%] - when Land property type is appear 4 times among all property type.

So, please suggest what to do now.

Thanks,

Sandip

Re: Need pie chart help - gap between pie chart regions

fred_s — Sun, 19 Apr 2015 08:49:44 GMT

Hi Sandip,

I guess you have to share your file or at least a part of it.

For now your formula looks okay to me, so we have to take a look at the numbers..

Fred

Re: Need pie chart help - gap between pie chart regions

ananyaghosh — Sun, 19 Apr 2015 14:30:30 GMT

Hi,

I have attached my .qvw file. Please go through it.

I think I almost done the thing, but when I select a particular area , it shows 100% which I think a error on my Pie Chart.

Thanks,

Sandip

Re: Need pie chart help - gap between pie chart regions

fred_s — Sun, 19 Apr 2015 16:37:20 GMT

Hi Sandip,

I think you're ready.

The fact that it's showing 100% after selecting 1 area is correct.

After all, after selecting that area, all your data, 100%, is part of that area.

Grtz Fred

Re: Need pie chart help - gap between pie chart regions

ananyaghosh — Sun, 19 Apr 2015 17:15:00 GMT

Hi Grtz Fred,

Have u checked my qvw file? is it ok or show correct data for the pie chart?

Thanks,

Sandip Ghosh

Re: Need pie chart help - gap between pie chart regions

fred_s — Sun, 19 Apr 2015 18:02:01 GMT

Hi Sandip,

Your Pie is perfect this way!

Total count is 108, so the 36 Assembly is 33%.

Fred

Re: Need pie chart help - gap between pie chart regions

Anonymous — Sun, 19 Apr 2015 18:15:58 GMT

Very small change

Re: Need pie chart help - gap between pie chart regions

ananyaghosh — Sun, 19 Apr 2015 18:31:22 GMT

hi,

i have a qlik view personal edition.so can't open the file. so please give me a screen shot what you have made changes to my qvw?

thanks

sandip ghosh

Re: Need pie chart help - gap between pie chart regions

Anonymous — Sun, 19 Apr 2015 18:34:04 GMT

Sure. The second expression is

[Property Type] & chr(10) & num(count([Property Type])/Count(total [Property Type]), '##.##%')

The chart is: