He was removed from his specialist unit and told to carry out ordinary police duties, which he also took exception to.
His career effectively ended on May 9, 2010 when he entered an unnamed nightclub on ordinary police duties, accompanied by another police officer and two military officers.
Authority member Rosemary Monaghan heard how a woman, referred to as 'V',removed Q's police hat from his head.
"The authority was told such pranks are not uncommon, and that tolerance is the best approach," the determination said.
"However, Q took the matter seriously and sought to speak to V about it outside the club."
The officer's colleague complained to the Independent Police Conduct Authority about his conduct two days later.
She alleged that Q placed the woman in a "headlock/choker hold, dragged her into the nightclub's hallway and yelled at her, then dragged her outside".
Q denied the excessive force allegations.
He said the woman's behaviour had been unruly and that he used an approved technique to restrain her and eject her from the nightclub.
The officer complained that he was prejudiced because delays meant he was unable to obtain any CCTV footage of the incident, which he believed would clear him of any wrongdoing.
But after an investigation, the officer was sacked on October 14, 2011.
The authority agreed with the decision, saying the finding of excessive force was one that a fair and reasonable employer could reach.
Ms Monaghan concluded that the officer exercised poor judgment during the incident while his attitude to the woman was "disparaging and belittling".
"He considered the hold he used to be necessary and appropriate, when it is at best doubtful that the hold he used was the minimum restraint necessary in the circumstances," she said.
"He believed it was necessary to show anger in order to control V, but that was a poor exercise of judgment.
"He was unable to see that his actions appeared heavy-handed."
Costs were reserved.
