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: 
Not applicable

Calculation result not as expected

Hi All,

This is my first post, so be easy on me. 🙂

I have a strange probleem that I think should be solved quite easily.

I have the following data as an example:

ID length

1 180

2 345

3 180

I tried the following expression in a textbox:

1. sum(length) = 705 <= correct and as expected

2. count(length) = 3 <= correct and as expected

3. avg(length) = 0.16319444 <= incorrect, expected 705/3 = 235

4. sum(length)/count(length) = 0.16319444 <= incorrect, expected 705/3 = 235

What should I do to get the correct value '235' ? I dont quite understand why it calculates 0.16319444 instead of 235.

Thank you in advance.

1 Solution

Accepted Solutions
Not applicable
Author

Hi,

here is a solution:

avg(num#(frame1,'#'))

it seams like frame1 is not formated as a number

Hope this helps!

Regards!

View solution in original post

6 Replies
Not applicable
Author

Hi there,

I think there is something wrong when you load your date, because I create your scenario and both expresions: avg(length) and sum(length)/count(length) gives me 235 for result

Can you upload your file?

I attached mine.

Regards!

Not applicable
Author

Hi Gabriela,

I attached my file.

Thank you for your reply.

Kind Regards.

Not applicable
Author

Hi,

here is a solution:

avg(num#(frame1,'#'))

it seams like frame1 is not formated as a number

Hope this helps!

Regards!

Not applicable
Author

Thanks Gabriela. Your solution works like a charm!

Could you explain a bit for me? I would like to understand a little bit more. Frame1/2/3 is an interval and not a number, so what kind of value is 0.16319444?

Thanks a lot!

jonathandienst
Partner - Champion III
Partner - Champion III

Hi

Here's why (from your sample):

Your script created a dual value that had a text representation in minutes that totalled 1925 when added, and a numeric value of day fraction. ie for ID 110, 180 minutes = 0.125 of 24 hours. 0.16319444 = 1.336806 / 6 which is correct.

IMO the total of 1925 is a bug as you should not be able to total the text representation, as shown by the inability to total the expression Text(frame1).

Column 4 shows how you can get numeric minutes from the value.

Hope that clears it up.

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

ok that clears up thing! Thank you for your explanation.