topic Re: Ratio calcuation in QlikView

Ratio calcuation

tmumaw — Sat, 16 Nov 2024 02:51:28 GMT

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

Re: Ratio calcuation

dplr-rn — Wed, 31 Jul 2019 14:46:36 GMT

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

Re: Ratio calcuation

tmumaw — Wed, 31 Jul 2019 14:51:59 GMT

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.

Re: Ratio calcuation

dplr-rn — Wed, 31 Jul 2019 14:54:16 GMT

Why not append the 2 counts?

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

Re: Ratio calcuation

Brett_Bleess — Thu, 22 Aug 2019 16:04:46 GMT

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