# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for
Did you mean:
Not applicable

## Calculation in script and number format

I have two questions.

1) I have a field that comes in as 199.00 instead of 1.99 so I put it as an expression in a chart and divided it by 100 to see it as 1.99 but I want to see this as a percent so when I set it as a "Fixed to 2 decimals" and "Show it as a percent" , it shows me 199.00%. Any way to fix this in the expression calculation or script? I want to be able to see 1.99%

1) Is there an easy way to do a sum calculation in the script?  I have a field that is extracted in seconds but I need it in hours. So I want to be able to calculate this in the script for performance reasons. The below seems to be unacceptable. How can I do this in the script without making it overly complicated?

Speed,

Speed/2600 as [Speedhours],                                    // doesn't seem to get the right answer

SUM(Speed/3600) as [Speed in hours],                    //  doesn't work, errors

Otherfields,

Otherfields1,

From **

1 Solution

Accepted Solutions
MVP

Hi,

```LOAD
Num(field1/100, '0.00%') as field1,
Speed,
Speed/3600 as [Speed in hours]
Inline [
field1, Speed
199.00, 10
];
```

hope this helps

regards

Marco

2 Replies
Creator III

1 - Try dividing it by 10,000 instead

2 - In order to do sum's (aggregations), you need to group by all the fields that are not part of the sum.

Group By

Speed,

Otherfields,

Otherfields1

That way you can sum at the correct level.

MVP

Hi,

```LOAD
Num(field1/100, '0.00%') as field1,
Speed,
Speed/3600 as [Speed in hours]
Inline [
field1, Speed
199.00, 10
];
```

hope this helps

regards

Marco

Community Browser