topic Re: Navigation in Pie chart in QlikView

Navigation in Pie chart

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

I have a calculated dimension as below:

=If($(vAllocation)>7 , 'Occupied',

If($(vAllocation)<4 , 'Available',

If($(vAllocation)>3 and $(vAllocation)<8 , 'Partial Occupied')))

and expression as:

=count(DISTINCT EmployeeID)

It is showing the chart as

on selecting the above chart it must navigate to another sheet.

How can I achieve it anybody help me.........

Regards

Yoganantha Prakash G P

Re: Navigation in Pie chart

krishnacbe — Mon, 17 Apr 2017 16:29:53 GMT

Hi,

Create the dimension in Script and create the chart.

Create a Field Event Trigger - On Select to navigate to other Sheet.

Re: Navigation in Pie chart

Anonymous — Mon, 17 Apr 2017 16:30:44 GMT

As you have static number of values in pie chart How about creating transparent text boxes on the chart and pulling trigger in the textbox??

Re: Navigation in Pie chart

yoganantha321 — Mon, 17 Apr 2017 16:31:30 GMT

Hi Krishnapriya,

I must strickly not to disturb the data model by adding extra field

Re: Navigation in Pie chart

Nicole-Smith — Mon, 17 Apr 2017 16:31:45 GMT

Put a transparent text object over the pie chart and set the action on it to activate the sheet you want.

I've attached an example file with this functionality.

Re: Navigation in Pie chart

yoganantha321 — Mon, 17 Apr 2017 16:32:06 GMT

It is not static values.

Re: Navigation in Pie chart

Anonymous — Tue, 18 Apr 2017 05:55:32 GMT

Not static values, but there are fixed number of values which is 3. You can create empty text boxes and transperent and use them as triggers by placing them on the pie chart, each on one sector.

Re: Navigation in Pie chart

yoganantha321 — Thu, 20 Apr 2017 10:28:08 GMT

No, It is not associating with the navigating sheet....... It must also associate with the navigating sheet.

Re: Navigation in Pie chart

awhitfield — Thu, 20 Apr 2017 10:43:31 GMT

To Confirm: you can't add an action directly to a chart. You will have to use a worked around

Andy

Re: Navigation in Pie chart

Anonymous — Thu, 20 Apr 2017 11:16:40 GMT

Dint understand you by "not associating with the navigating sheet.". But check if this is what you want.