Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Percent of column calculation

I'm trying to do a win/loss analysis and want to figure out the best way to determine wins, loss, DQ.

The data looks like:

Competitor Name     Status     Distinct (Opp ID)      Win/Loss rates

Comp A                    Won             673                               %

Comp A                    Lost              221                               %

Comp A                    DQ               425                                %

I assume the best way is to create an if/then expression that returns won, lost or dq but I don't know how to have it show as a percentage vs. a #.

Any ideas?

2 Replies
ogster1974
Not applicable

Re: Percent of column calculation

Do a pie chart on status counting the distinct number of opportunities which a filter on competitor name should give you a nice start.

a KPI on count(<Status={'Won'}> [Opp Id]) / count([Opp Id]) should give you the win rate with formatting as a percentage applied.

jpe
Not applicable

Re: Percent of column calculation

a few ways but the TOTAL method is pretty easy:

count( Distinct [OppID])

/

count( TOTAL  Distinct [OppID])