topic Re: Pie chart selection in Setanalysis in QlikView

Pie chart selection in Setanalysis

Thu, 20 Oct 2011 14:03:33 GMT

Hi Guys,

I know that when a setanalysis expression is given like this in a piechart

Count({<[Process version_VERSION]={'Version_1'},Department={'IT'}>} Distinct [Composite role/User_UNAME])

it is hardcoded but what I need is that these fields are selected when I select a part in a piechart.

Hope anyone can help! Any Ideas?

Thanks

Sravan

Re: Pie chart selection in Setanalysis

Thu, 20 Oct 2011 14:27:08 GMT

Does this solve your problem? I added actions in Docproperties->Triggers->field event triggers:

Field: Risk level

Trigger: On select.

Regards,

Kiran.

Re: Pie chart selection in Setanalysis

jonathandienst — Thu, 20 Oct 2011 14:39:34 GMT

Sravan

Perhaps I've not understood your requirement, but do you mean that you want to view the count of whatever you've selected in the piechart? If that is the case, you just need to lose the part(s) of the set analysis that you are selecting.

Hope that helps

Jonathan

Pie chart selection in Setanalysis

Fri, 21 Oct 2011 11:26:58 GMT

Hi Jonathan,

But when I click on the No of users in the Piechart, I cannot get the selections like the Department and Version selected automatically. Without setanalysis pie chart does not run.

Kiran gave a route to work and it is what I need. Though kiran's work for whole Document. I need to make per Object to get it right!

Thanks for your help

Sravan

Re: Pie chart selection in Setanalysis

Fri, 21 Oct 2011 13:19:05 GMT

This solves the problem of "having at Object Level". Please check the attachment. Sheet triggers for chart35. Macro called at document level On Field selection.

Regards,

Kiran.