topic Re: pie chart in QlikView

pie chart

Thu, 25 Sep 2014 07:46:44 GMT

Hi,

I have Zone field with fieldvalues- Zone1, Zone2, Zone3

and State field with fieldvalues- AP, Gujarat, Punjab, UP, Tamil Nadu , Kerala

Now, I have created a pie charts showing count of managers with a dimension as Activity

The requirement is when I select 1 zone , I am supposed to create 2 pie charts for the associated states and when I select other zone the same charts will be showing the associated data.

eg if I select Zone1 then the 2 pie charts should show AP and Gujarat data whereas when I select Zone2 same charts should show Punjab and UP data.

This I am trying to implement as it will reduce the number of pie charts required.

Thanks in advance!!

Re: pie chart

sasikanth — Thu, 25 Sep 2014 07:52:56 GMT

try to enable the state dims based on conditons

EX;

add all the dims (states)

create condition and check ENABLE CONDITIONAL

for AP and GUJARATH

getFieldSelections(ZONE)='Zone1'

similar for all zones

Hope it helps

Thanks

Sasi

Re: pie chart

jyothish8807 — Thu, 25 Sep 2014 08:01:23 GMT

Hi Rajeshree,

Can you share your sample data sourse?You can acheive this by setting up an condition like

if(getFieldSelections(ZONE)='Zone1',count({<state={'AP','Gujrat'}>}Manager),if(getFieldSelections(ZONE)='Zone2',count({<state={'AP','Gujrat'}>}Manager) ........

Something like this.

Hope it works

Regards

Re: pie chart

jyothish8807 — Thu, 25 Sep 2014 08:02:03 GMT

change the state in else if condition.

Regards