topic Re: Pie chart trigger in QlikView

Pie chart trigger

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Guys,

I have a pie chart showing three type of employee's count (Available, Occupied and Partially Occupied). If I select only available employees it should be navigated to another sheet and to enable the available filter option in that sheet. Similarly for occupied and Partially occupied employees. Plz let me know if it is possible? if it is how to do? Plz help me guys....

Re: Pie chart trigger

adamdavi3s — Fri, 24 Feb 2017 13:09:54 GMT

Hi Siva,

This is certainly possible, you could do it as an event trigger on the field employee type (under document properties)

Depends if you want to trigger it just for that specific chart or not?

Re: Pie chart trigger

adamdavi3s — Fri, 24 Feb 2017 13:14:29 GMT

Here is an example, note that the same happens if you select the chart or the listbox

Edit sorry just updated the example to only trigger on available

Re: Pie chart trigger

MK9885 — Fri, 24 Feb 2017 13:28:22 GMT

Yes it is doable.

If your (Available, Occupied and Partially Occupied) are measure then probably store them as a variable and use this IF condition in layout for the sheets or create a trigger as mentioned by Adam.

If they are dimensions, same can be done.

Re: Pie chart trigger

Anonymous — Fri, 24 Feb 2017 14:03:54 GMT

Thank you guys, But in filter I have calculated dimension expression How can I achieve it?

Re: Pie chart trigger

adamdavi3s — Fri, 24 Feb 2017 14:10:11 GMT

can you give us a sample to work with?

Re: Pie chart trigger

Anonymous — Fri, 24 Feb 2017 14:16:52 GMT

Adam, I'm using this expression as calculated dimension in filter,

=IF( MonthlyWorkHour>7, 'Occupied', IF( MonthlyWorkHour>3 and MonthlyWorkHour<8, 'Partially Occupied', IF( MonthlyWorkHour<4, 'Available' )))

Re: Pie chart trigger

adamdavi3s — Fri, 24 Feb 2017 14:27:20 GMT

Ok check this out, sorry used my own field names.

There is now a variable and a trigger on this variable

Re: Pie chart trigger

MK9885 — Fri, 24 Feb 2017 14:37:14 GMT

Can post a sample app?

Re: Pie chart trigger

Anonymous — Sat, 25 Feb 2017 05:56:23 GMT

when I clicked on available (red region) in the chart, it should be navigated to another sheet enabling available option having the filter as shown below,

Plz help me guys, I'm having calculated dimensions in this filter, so I'm confused...

Re: Pie chart trigger

Anonymous — Sat, 25 Feb 2017 07:34:43 GMT

how about creating the dimension in the script itself and using it in the pie chart and then putting a trigger.

Re: Pie chart trigger

Anonymous — Sat, 25 Feb 2017 08:23:29 GMT

Dear siva

I did it by tigger on Document propertise

Re: Pie chart trigger

Anonymous — Sat, 25 Feb 2017 08:49:14 GMT

Thank you so much... I got this for pie chart and also I need it using gauge charts.

Re: Pie chart trigger

Anonymous — Sat, 25 Feb 2017 11:18:44 GMT

if you find my solution true please mark it as correct answer

Re: Pie chart trigger

adamdavi3s — Mon, 27 Feb 2017 07:53:19 GMT

sivabose‌ what was wrong with this solution?