topic Re: Show ratio in simplest form in QlikView

Show ratio in simplest form

yashcena — Wed, 26 Jul 2017 13:15:44 GMT

I'm working on an analytics app which has information about scrum team, resources and their roles (developer, tester, dba etc.)

I have to show the ratio of developers to testers for each scrum team in the simplest form (Ex: 4 dev & 6 testers = 2/3).

For now, I'm just showing the count(dev) '/ ' count(tester) which is simply displaying both the counts with a '/' in between. No calculation is being made.

What do I need to do to get the simplest ratio? Is it possible at all?

Hope I have made my requirement clear.

Thanks,

YASH

Re: Show ratio in simplest form

ahaahaaha — Wed, 26 Jul 2017 13:40:33 GMT

Hi,

Why quote?

count(dev) / count(tester)

Re: Show ratio in simplest form

yashcena — Wed, 26 Jul 2017 13:43:12 GMT

if i dont give the quote, it simply divides the two counts. I want it in x/y or x:y format

Re: Show ratio in simplest form

ahaahaaha — Wed, 26 Jul 2017 13:47:32 GMT

Expression count(dev) / count(tester) should work. Is it possible to have several rows of data on which you are calculating?

Re: Show ratio in simplest form

yashcena — Wed, 26 Jul 2017 13:50:14 GMT

This expression works fine. But the issue here is this:

For 5 dev and 10 testers, that expression would return 0.50. I want 1:2 i.e. 5/10 in simplest form

Re: Show ratio in simplest form

ahaahaaha — Wed, 26 Jul 2017 14:05:26 GMT

May be

count(dev)&' /'& count(tester)

Re: Show ratio in simplest form

yashcena — Wed, 26 Jul 2017 14:20:46 GMT

I'm using this expression itself now. So 5 dev and 10 tester would give me 5/10 in the chart. I want to see 1/2 which is the simplest form of 5/10.

5'/'10 would display 5/10 in the chart.

just 5/10 would display 0.50 in the chart

What do I need to write in the expression dialogue box so that 1/2 or 1:2 is displayed?

Re: Show ratio in simplest form

eknezo24 — Thu, 15 Feb 2018 20:44:56 GMT

I used this and it worked for me!

Count([dev])&' : '& count([tester])