Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Help with Set Analysis in Pie chart

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

1 Solution

Accepted Solutions
Highlighted
Not applicable

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

View solution in original post

4 Replies
Highlighted
Not applicable

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

View solution in original post

Highlighted
Creator
Creator

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

Highlighted
Not applicable

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

Highlighted
Creator
Creator

Hi Roland,

I have fixed the Pie Pieces and uploaded a new example

have a look and see if its ok

regards Peter