topic Re: RE:Ratio in QlikView

RE:Ratio

Chanty4u — Mon, 28 Dec 2015 12:12:02 GMT

Hi all,

I need to calucalte the raio between

Frmulae: Onsite Hours/Offshore Hours

Dim:Period

sample data lik dis

year	period	on_0ff_flag	total_hrs	total_amt
2011	Per10	Onsite	152	456
2011	Per10	Onsite	152	456
2011	Per10	Onsite	72	216
2011	Per10	Offshore	152	304
2011	Per10	Offshore	152	304
2011	Per10	Offshore	8	16
2011	Per10	Offshore	142	284

how can i achve dis?

thanks

Suresh

Re: RE:Ratio

swuehl — Mon, 28 Dec 2015 12:15:06 GMT

Maybe with an expression like

=Sum({<on_0ff_flag = {'Onsite'}>} total_hrs) / Sum({<on_0ff_flag = {'Offshore'}>} total_hrs)

Re: RE:Ratio

ajsjoshua — Mon, 28 Dec 2015 12:18:26 GMT

Hi try this

=SUM({$< on_off_flag={Onsite}>}total_hrs) /SUM({$< on_off_flag={Offshore}>}total_hrs)

Re: RE:Ratio

Anonymous — Mon, 28 Dec 2015 12:23:07 GMT

Try as swuehl‌ suggested, then in number tab, select show in percent(%)

Re: RE:Ratio

Chanty4u — Mon, 28 Dec 2015 12:29:16 GMT

thnx swuel..

but i need from total count of offshre and onsite.....

example:

onsite :376/830

in 830 total offshre +onsite...

how can i?

Re: RE:Ratio

sunny_talwar — Mon, 28 Dec 2015 12:31:18 GMT

Try this:

=Sum({<on_0ff_flag = {'Onsite'}>} total_hrs)/Sum(total_hrs)

Re: RE:Ratio

swuehl — Mon, 28 Dec 2015 12:32:00 GMT

Maybe just like

=Sum({<on_0ff_flag = {'Onsite'}>} total_hrs) / Sum(total_hrs)

for onsite and

=Sum({<on_0ff_flag = {'Offshore'}>} total_hrs) / Sum(total_hrs)

for offshore.

Re: RE:Ratio

Chanty4u — Mon, 28 Dec 2015 13:27:11 GMT

thanx swuehl...

this is

=Sum({<onsite_offshore_flag = {'Onsite'}>} total_hrs)/Sum({<onsite_offshore_flag = {'Offshore'}>} total_hrs)&'%'

wat i used but in textbox it is shwng 0.3191850594%

how to show in 2digits lik 31%..?

Re: RE:Ratio

Anonymous — Mon, 28 Dec 2015 13:30:08 GMT

try like this:

=num(Sum({<onsite_offshore_flag = {'Onsite'}>} total_hrs)/Sum({<onsite_offshore_flag = {'Offshore'}>} total_hrs)*100,'#.##')&'%'

Re: RE:Ratio

sunny_talwar — Mon, 28 Dec 2015 13:30:46 GMT

‌Try this

=Num(Sum({<onsite_offshore_flag = {'Onsite'}>} total_hrs)/Sum({<onsite_offshore_flag = {'Offshore'}>} total_hrs), '##.00%')

Re: RE:Ratio

Anonymous — Mon, 28 Dec 2015 13:32:24 GMT

this as well:

=num(Sum({<onsite_offshore_flag = {'Onsite'}>} total_hrs)/Sum({<onsite_offshore_flag = {'Offshore'}>} total_hrs)*100,'0')&'%'