topic Re: Need help on scripting this in QlikView

Need help on scripting this

Fri, 04 May 2012 12:42:53 GMT

I need to set up a pie chart. The user will select a Campaign in the CampaignName list box and the pie chart will show all of the industry's, from the Industry field that are associated with the Campaign. If I only had 5 industries this would be no issues as I could just do 5 expression in the chart. However, I have about 20+ and if more are added in the system I am pulling data from I would have to update the graphs each time. Any suggestions on how to script this or use set analasys that would pick up all industry's to where if I had 1 or 50 they would all be identified? Any script example you could share would be awesome. Thanks much.

Re: Need help on scripting this

jonathandienst — Fri, 04 May 2012 13:10:43 GMT

Sean

You would not normally use an expression for each slice of a pie chart.

In your case, Industry would be the dimension on the chart and you would need a single expression.

Regards

Jonathan

Re: Need help on scripting this

Fri, 04 May 2012 13:38:42 GMT

Hi, attached a qvw, i hope can help you.

In the first graphic "Industry" is used as dimension only, select a "Campaign" in the list box and filter wath you want to see.

In the second graphic "Industry" and "Campaign" are used as dimension. In the inner circle appear Campaign.

Maybe need modify colors to make ir more clear.

Sorry for my bad english.

Regards.-