Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

problems with big numbers..

Hi everyone...

I have this number (4,0084464e+011) inside my script.. this come from the sum of a field in one table..

Now I need to get the 86% of this number, but my attemps seems to fail miserably...

let por86 = num($(sumatotal)) * 86/100; this is getting the wrong answer 3.44

let por86 = $(sumatotal) * 86/100; this is throwing a script error (probably the way the number is show)..

So How can I calculate this value? Or should I do it in the load of the sum? (didn't try it, this just come into my head)

Thanks...

Tags (2)
5 Replies
MVP
MVP

problems with big numbers..

Maybe a good idea to do the 86% at a different place...

Where and how do you define your variable sumatotal? Could you post some more lines of your script?

Not applicable

problems with big numbers..

This is my script

SumaTotal:

          LOAD

                    Sum(total_general) as sumtotal

          Resident

                    Final1;

 

          let sumatotal = Peek('sumtotal',0,'SumaTotal');

Where else can I do this??? Mabye port the sum to a number?

I tried this:

SumaTotal:

          LOAD

                    Sum(total_general) * 86 / 100 as sumtotal

          Resident

                    Final1;

and seems to work, but if this ok?

Not applicable

problems with big numbers..

Ok, I tried some more.. and realize I could fix it, just multiplying it by 1.

so this:

SumaTotal:

          LOAD

                    Sum(total_general) *1 as sumtotal

          Resident

                    Final1;

will fix the number and allow to make calculus with the number.. don't understand the difference.. but it worked.

(in fact I can also do this: Sum(total_general) * 86 / 100 as sumtotal and will work).

MVP
MVP

problems with big numbers..

So you've solved your issue? Good to hear!

QlikView seems to have some issues with large numbers, interpreting them as string only while loading. Not sure if this is what you see and if this is version specific, but if you are interested in, there are some threads that are related to problems with large number while loading from source.

Have a nice weekend,

Stefan

Not applicable

problems with big numbers..

I found some threads about problems with numbers, but usually they involved loading numbers from database, not calculating it. And seems in charts there are no problems with them, I assume they should work. But not, the problem is even when you calculate them.

Would be nice to heard a word from qt about why if I just multiply it by 1, it becomes a number again.

Thanks anyway...

Community Browser