Can't convert to percentages...

[#1]

So I am very new to Qlikview so I apologize if this is simple.

I have a table titled DCReason that lists reasons for discharges. This information is linked to another table titled Branches (these are our office branches).  I want to produce a graph that lists the discharge reasons and displays them as a percent so that when I click on a branch office, I can see what % of people were discharged for each reason.

I've tried doing sum(DCReason)/sum(Total DCReason). I also tried playing around with the fractile function but nothing . All I am able to do is produce a graph taht shows the absolute number (Textcount (DCReason))

[jvitantonio]

Mmh I think there's something wrong in the model. Are you sure you have to tables? If yes, you should have a Value field where it says the number of time a particular reason happened. Youshould sum that fieldn instead of the Reason description. I guess you should have something like:

Branch	Reason
idBranch	idBranch
Branch Description	IdReason
	Reason Description

youshould do count(idReason)/count(total idReason)

[#3]

Yea. One table is titled DCreasons and has all the reasons (as noted above) and the other other is titled Branch and contains the name of the branches. I know they're linked because when I click on a branch, the graph that I attached changes and shows the absolute numbers.

[#4 · Accepted solution]

Use the 'Table Viewer' to see how the 2 tables are inter-connected.

Ideally the formula Count(DCreasons)/Count(TOTAL DCreasons) should give you a percent.

[#5]

That expression worked! Thank you very much. I guess my problem was using textcount instead of count.