Help with Set Analysis in Pie chart

[Peter_Brunner]

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

[#2 · Accepted solution]

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

[Peter_Brunner]

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

[#4]

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  )

RR

[Peter_Brunner]

Hi Roland,

I have fixed the Pie Pieces and uploaded a new example

have a look and see if its ok

regards Peter