Ratio calcuation

[tmumaw]

Good Morning Everyone,

I have a request to calculate the number of hires per requisition.  For example I have 4 requisitions and I hired 1 employee that would make my ratio 4:1.  Is there an easy way to achieve this in Qlikview?

Thanks

[dplr-rn]

could you expand on the problem a little more?
i am sure its more complicated that it appears on first .

[tmumaw]

Nothing else to expand on.  I have 4 requests and I was able to fill 1.  Just trying to figure out the calculation to show this (4:1) ratio.

[dplr-rn]

Why not append the 2 counts?

count(requis)&':'&count(hires)

[Brett_Bleess]

Hey Thom, did Dilip's suggestion work in this case, or are you still trying to sort something out on this one?  If that did work, use the Accept as Solution to mark that as the solution, if that is giving you trouble, just leave a new post letting me know, and I can mark it for you in that case.

Sorry I do not have anything useful to add on this one!  The only place I could point you is the Design Blog area to see if anything out there may be of use:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Cheers,
Brett