topic Re: Issue on pie chart in QlikView

Issue on pie chart

Wed, 25 Nov 2020 16:16:04 GMT

i have requirement on pie chart

1)in my pie chart i have 5 regions for eg:North ,east ,West,South,central

2)each zone having different Values for eg:North=20%,south=30%,west=30%,east=10%,central=25%

now my requirement is

When ever i select any zone (east,west,north,south,central) my pie chart should show all the zones instead of selected zone and also it has to highlight the selected zone.

how to archive this ......

Thanks

Re: Issue on pie chart

sunny_talwar — Fri, 18 Mar 2016 09:14:45 GMT

Add set analysis to you expression to ignore any selection in zone field. If you expression was this:

Sum(Sales)/Sum(TOTAL Sales) -> Change it to Sum({<Zone>} Sales)/Sum(TOTAL {<Zone>} Sales)

For second part of your question, may be set color using background color

If(Sum(Sales) > 0, LightRed(), LightGray())

Re: Issue on pie chart

ramasaisaksoft — Fri, 18 Mar 2016 09:56:16 GMT

expression:-

sum({1}Sales) will give always full amount of data .

Re: Issue on pie chart

Anonymous — Fri, 18 Mar 2016 10:36:24 GMT

try to follow the below mentioned steps to achieve above requirement:

1) create pie chart dim region and sum({1}Amount)

2)in the colour properties of the chart use below expressions

if(GetFieldSelections(Region)='4',rgb(102,255,102),rgb(98,138,183))

if(GetFieldSelections(Region)=5,rgb(102,255,102),rgb(252,115,98))

if(GetFieldSelections(Region)=6,rgb(102,255,102),rgb(125,152,35))

if(GetFieldSelections(Region)=7,rgb(102,255,102),rgb(210,173,0))

if(GetFieldSelections(Region)=8,rgb(102,255,102),rgb(65,160,115))

Data:

T1:

LOAD * INLINE [

Region, orderDate, Product, Amount

4, 1/4/2011, Case 4, 500

5, 1/5/2011, Case 5, 200

6, 1/4/2011, Case 4, 300

7, 1/5/2011, Case 5, 400

8, 1/2/2011, Case 5, 800

];

Exp:

sum({1}Amount)

Output:

no region is selected:

Region 4 is selected and it is highlighted in green and data for other region is also there

now Region 5 is selected and it is highlighted in green and data for other region is also there

hope this will help you.....

Re: Issue on pie chart

Fri, 18 Mar 2016 17:30:33 GMT

great

thanks

Re: Issue on pie chart

Fri, 18 Mar 2016 18:59:56 GMT

Getfieldselections not working That is if conditions

Re: Issue on pie chart

MarcoWedel — Sat, 19 Mar 2016 01:40:02 GMT

Hi,

another solution might be:

hope this helps

regards

Marco

Re: Issue on pie chart

Anonymous — Sat, 19 Mar 2016 03:37:43 GMT

Plz share your expression....

Re: Issue on pie chart

Mon, 21 Mar 2016 16:53:56 GMT

i have written some thing like color(fieldindex('Zone',Zone)) in BG color

Re: Issue on pie chart

Mon, 21 Mar 2016 16:55:36 GMT

i want all the colors in background not only white and selected color.

Re: Issue on pie chart

MarcoWedel — Mon, 21 Mar 2016 23:21:12 GMT

Hi,

then try like this:

Re: Issue on pie chart

Anonymous — Tue, 22 Mar 2016 04:51:46 GMT

Hi Abubakar,

go to the chart properties-->Colors-->Data Aperance like shown in below screen shot:

use below expressions :

if(GetFieldSelections(Region)='4',rgb(102,255,102),rgb(98,138,183))

if(GetFieldSelections(Region)=5,rgb(102,255,102),rgb(252,115,98))

if(GetFieldSelections(Region)=6,rgb(102,255,102),rgb(125,152,35))

if(GetFieldSelections(Region)=7,rgb(102,255,102),rgb(210,173,0))

if(GetFieldSelections(Region)=8,rgb(102,255,102),rgb(65,160,115))

hope this will help you...

Re: Issue on pie chart

Tue, 22 Mar 2016 17:55:36 GMT

Great job

Thanks