topic Help with Set Analysis in Pie chart in QlikView

Help with Set Analysis in Pie chart

Peter_Brunner — Mon, 01 Oct 2012 13:30:47 GMT

Hi All,

I am new to QlikView and having an issue with a set analysis syntax.

I wish to have each Reps Name in separate Pie Charts showing each Reps Sales percentages.

I have Negative and Positives Percent values "which I have working no problems see attached example"

but now I need to add the set Analysis per Rep.

I have tried several different syntaxes with no luck

Thanks for Help

Regards Peter

Re: Help with Set Analysis in Pie chart

Mon, 01 Oct 2012 14:48:49 GMT

Hi Peter,

you should be able to use "{< Rep={'Harry'} >}" (or any other Rep-Name, of course) in all of your expressions:

Example:

fabs(Sum({< Rep={'Harry'} >} Margin)/(fabs(Sum({< Rep={'Harry'} >} Sales))))-1

works for me.

Regards

Roland

Re: Help with Set Analysis in Pie chart

Peter_Brunner — Tue, 02 Oct 2012 00:04:57 GMT

Hi Roland it worked !

Thank you very much.

I have attached a Working Example for others to refer to

thanks to Roland for help with this

Cheers Peter

Re: Help with Set Analysis in Pie chart

Tue, 02 Oct 2012 07:31:34 GMT

Hi Peter,

glad to help you.

I am wondering if your endusers don't mind that the pieces of the pies don't match with their corresponding values. Regarding the pie it seems to me that Bill's Margins are equal (but in fact they are 6.7, 10 and -4 )

Re: Help with Set Analysis in Pie chart

Peter_Brunner — Tue, 02 Oct 2012 23:52:07 GMT

Hi Roland,

I have fixed the Pie Pieces and uploaded a new example

have a look and see if its ok

regards Peter