Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Chanty4u
MVP
MVP

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

thnaks in advance.

Suresh

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

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.

View solution in original post

13 Replies
HirisH_V7
Master
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!”
jagan
Luminary Alumni
Luminary Alumni

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.

Chanty4u
MVP
MVP
Author

is aanything wrng in exp?

Please correct it?

jagan
Luminary Alumni
Luminary Alumni

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.

Chanty4u
MVP
MVP
Author

hi jagan,

Both are nt frm same table.

we are created in script.

lik  Sum(1) as E_Count

resident frm fact table?

jagan
Luminary Alumni
Luminary Alumni

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.

Chanty4u
MVP
MVP
Author

if i use abve exp the value cmg as  53175.56

and frst exp  if i use   its gvng 0.17?

HirisH_V7
Master
Master

Hi suresh,

Does it work fine?

-Hirish

HirisH
“Aspire to Inspire before we Expire!”
Chanty4u
MVP
MVP
Author

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