topic Re: RE:How to Do Productivity? in QlikView

RE:How to Do Productivity?

Chanty4u — Tue, 05 Jan 2016 12:18:57 GMT

hi all,

i have fields lik

t_id	t_desc	t_hrs
47	Onst/Offshr	5
47	Test - Exe - ST 47 Test-Des-ST	20
47	Onst/Offshre	5
47	Non-RT	6

1)where ST and RT are the string values.

and in ST design is there and too RT also hvng design

i need to caluclate

Effort spent in days? how to do this?

Re: RE:How to Do Productivity?

sunny_talwar — Tue, 05 Jan 2016 12:26:35 GMT

Not sure I understand what your expected output is

Re: RE:How to Do Productivity?

Anonymous — Tue, 05 Jan 2016 12:28:19 GMT

Effort for what? Designing? Execution?

If it is for designing then try like this:

=sum({<t_desc={'*des*'}>} t_hrs)/24 which would give you number of days for designing

Re: RE:How to Do Productivity?

Peter_Cammaert — Tue, 05 Jan 2016 12:28:27 GMT

You didn't specify over which dimensions this calculation should be performed, so this will probably do:

=Sum(t_hrs)/24

If not, please specify which dimensions you want to use (in for example a straight table) or post a screenshot of the desired object. You can simulate your object in Excel.

Best,

Peter

Re: RE:How to Do Productivity?

Chanty4u — Tue, 05 Jan 2016 12:37:35 GMT

yes i want to caluculate..

for design

Re: RE:How to Do Productivity?

Anonymous — Tue, 05 Jan 2016 13:05:21 GMT

Try these expression:

I am assuming mentioned format by you

SIT:

=sum({<t_desc={'*design*SIT'}>} t_hrs)/24

RT:

=sum({<t_desc={'*design*RT'}>} t_hrs)/24

Re: RE:How to Do Productivity?

Peter_Cammaert — Tue, 05 Jan 2016 13:10:45 GMT

I'm sincerely sorry, but I do not understand your requirement. If you want calculations to be done in a pivot table (as shown in your screenshot), then the simple Sum(t_hrs)/24 will do. It's only a matter of choosing/generating the correct dimensions.

Alterantively, you can create two expressions (call them 'ST' and 'RT') and embed the required process in set analysis as others have shown before:

= Sum({<t_descr = {'Test-Des-ST'}>} t_hrs)/24

and

= Sum({<t_descr = {'Test-Des-RT'}>} t_hrs)/24

Note: these expression will be applied on all rows and won't allow changing process phases via set analysis (as your metrics dimension seems to imply). You'll have to use a nested IF expression instead.

Best,

Peter

Re: RE:How to Do Productivity?

Chanty4u — Tue, 05 Jan 2016 13:16:25 GMT

sry peter...

as that is testting metrics in Text object...