Qlik Community

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 
Search instead for 
Did you mean: 
Highlighted
Champion III
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),'###.##')

thnaks in advance.

Suresh

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
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.

View solution in original post

13 Replies
Highlighted
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!”
Highlighted
MVP & Luminary
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
Champion III

is aanything wrng in exp?

Please correct it?

Highlighted
MVP & Luminary
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
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
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.

View solution in original post

Highlighted
Champion III
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
Master

Hi suresh,

Does it work fine?

-Hirish

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

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