# QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for
Did you mean:
Highlighted Champion III

## RE:How it works?

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),'###.##')

Suresh

1 Solution

Accepted Solutions
Highlighted MVP & Luminary

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.

13 Replies
Highlighted Master

Hi ,

Check this ,

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

HTH,

Hirish

HirisH
“Aspire to Inspire before we Expire!”
Highlighted MVP & Luminary

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.

Highlighted Champion III

is aanything wrng in exp?

Highlighted MVP & Luminary

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.

Highlighted Champion III

hi jagan,

Both are nt frm same table.

we are created in script.

lik  Sum(1) as E_Count

resident frm fact table?

Highlighted MVP & Luminary

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.

Highlighted Champion III

if i use abve exp the value cmg as  53175.56

and frst exp  if i use   its gvng 0.17?

Highlighted Master

Hi suresh,

Does it work fine?

-Hirish

HirisH
“Aspire to Inspire before we Expire!”
Highlighted Champion III

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