Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

pie chart

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!!

3 Replies
sasikanth
Master
Master

Hi

try to enable the state dims based on conditons

EX;

add all the dims (states)

create condition and check ENABLE CONDITIONAL

like

for AP and GUJARATH

getFieldSelections(ZONE)='Zone1'

similar for all zones

Hope it helps

Thanks

Sasi

jyothish8807
Master II
Master II

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

KC

Best Regards,
KC
jyothish8807
Master II
Master II

change the state in else if condition.

Regards

KC

Best Regards,
KC