Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikview979
Specialist
Specialist

Functions

Hi experts,

How to use General numeric functions in script level ? with examples?

2 Replies
ThornOfCrowns
Specialist II
Specialist II

Have you tried looking at the Help file?

crusader_
Partner - Specialist
Partner - Specialist

Hi,

In the same way like in the front end:

LOAD *

     , floor(Qty) as Int_part

     , frac(Qty) as dec_part

;

LOAD * INLINE [

State, City, Qty

WA, Seattle, 101010.123123

CA, LosAngeles, 120323.1231

];

Hope this helps you.

P.S. Other type of functions uses in the same patern. Of course there are functions which can be used in script only and you can read about them in Help file.

Regards,

Andrei