topic Re: RE:How it works? in QlikView

RE:How it works?

Chanty4u — Mon, 11 Jan 2016 07:16:08 GMT

hi all,

Can anyone explain how it works?

explain the expression

am using this exp in Text Object.

Exp:

num(sum(Complexity * E_Count) / (sum({<cldes= {'TExe - IT','T Exe - MT','MT_Tep','RBD'}>}clhrs)/8),'###.##')

thnaks in advance.

Suresh

Re: RE:How it works?

HirisH_V7 — Mon, 11 Jan 2016 08:21:37 GMT

Hi ,

Check this ,

=num((sum(Complexity * E_Count) / sum({<cldes= {'TExe - IT','T Exe - MT','MT_Tep','RBD'}>}clhrs))/8,'###.##')

HTH,

Hirish

Re: RE:How it works?

jagan — Mon, 11 Jan 2016 08:43:45 GMT

Hi,

Exp:

num(sum(Complexity * E_Count) /

(sum({<cldes= {'TExe - IT','T Exe - MT','MT_Tep','RBD'}>}clhrs)/8),'###.##')

Calculates sum(Complexity * E_Count)

and then divides (sum({<cldes= {'TExe - IT','T Exe - MT','MT_Tep','RBD'}>}clhrs)/8)

What is the complexity in the expression.

Regards,

Jagan.

Re: RE:How it works?

Chanty4u — Mon, 11 Jan 2016 08:49:38 GMT

is aanything wrng in exp?

Please correct it?

Re: RE:How it works?

jagan — Mon, 11 Jan 2016 08:58:35 GMT

Hi,

I think syntax wise no issues.

Is Complexity and E_Count are in same table or different tables? If they are in different tables then try

num((sum(Complexity) * Sum(E_Count) )/

(sum({<cldes= {'TExe - IT','T Exe - MT','MT_Tep','RBD'}>}clhrs)/8),'###.##')

Hope this helps you.

Regards,

jagan.

Re: RE:How it works?

Chanty4u — Mon, 11 Jan 2016 09:05:32 GMT

hi jagan,

Both are nt frm same table.

we are created in script.

lik Sum(1) as E_Count

resident frm fact table?

Re: RE:How it works?

jagan — Mon, 11 Jan 2016 09:06:39 GMT

Hi,

Then use this expression

num((sum(Complexity) * Sum(E_Count) )/

(sum({<cldes= {'TExe - IT','T Exe - MT','MT_Tep','RBD'}>}clhrs)/8),'###.##')

Regards,

Jagan.

Re: RE:How it works?

Chanty4u — Mon, 11 Jan 2016 09:09:05 GMT

if i use abve exp the value cmg as 53175.56

and frst exp if i use its gvng 0.17?

Re: RE:How it works?

HirisH_V7 — Mon, 11 Jan 2016 09:29:35 GMT

Hi suresh,

Does it work fine?

-Hirish

Re: RE:How it works?

Chanty4u — Mon, 11 Jan 2016 09:31:06 GMT

both exp wrkng but how it is caluculating i cant u.stand?bcz its gvng diff values na

Re: RE:How it works?

Chanty4u — Mon, 11 Jan 2016 11:22:52 GMT

hi jagan,

The exp was correct ....but the issue is

new:

LOAD

Etest as Test_ID,

Sum(1) as ECount

Resident Fact_Table

Group By Etest;

problm wit gruop by?

Re: RE:How it works?

jagan — Tue, 12 Jan 2016 00:38:16 GMT

Hi,

Check with your user about his expected value and then use whatever the expression you required. User is the one who decides not we.

Regards,

Jagan.

Re: RE:How it works?

HirisH_V7 — Tue, 12 Jan 2016 03:33:36 GMT

Hi,

If you group by means the values corresponding or sub subsequent to that field will be Calculated.Based on Requirement you can fetch the result.

-HirisH

Re: RE:How it works?

Chanty4u — Tue, 12 Jan 2016 06:01:58 GMT

thnx hirish..

the issue is nt with values...

my req is:-

Example:

i have Prj1 and Prj2

Prj1:

Rer_Id and test cases

1--------- 3time

2---------3times

3 -----2times

4-------1time

Exc-id: exc-test

1 1

2 2

3 1

4 3

5 4

same for PRj2 also.

so wen am findng the complexicty its counting all PRJ1 aand PRJ2

but i need to get for 1req how many times excuted count shud be calucluate in script?