# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for
Did you mean:
Creator II

## calculate result municipal elections

Hi,

I come to you to help me find the best solution.

For municipal elections:

- Registration number: 12855

- No. of seats: 18

- Number of lists: 5

Suppose the election day we had the following results:

- Number of voters: 9643

+ List A: 5200

+ list B: 3000

+ list C: 800

+ list 😧 270

+ list E: 230

- Number of blank and invalid ballots: 143

To calculate the Nbs of seats for each list:

White ballots, void and Nbs of votes must be removed for lists obtained less than 3% of votes: 9643- 270-230-143 = 9000

- the electoral quotient 9000/18 = 500

Each lists gets

+ list A: 5200/500 = 10 seats remaining votes 200

+ list B: 3000/500 = 6 seats remaining votes 0

+ list C: 800/500 = 1 seats remaining votes 300

To assign the last seat to a list one must take the remaining most evaluate:

The rest of the list C is the most important 300 votes

The final result is:

+ list A: 10 seats

+ list B: 6 seats

+ list C: 2 seats

On each list 18 candidates numbered from 1 to 18

I would like to display the board composition according to the number of votes for each list.