topic Functions in QlikView

Functions

qlikview979 — Wed, 08 Jul 2015 13:01:23 GMT

Hi experts,

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

Re: Functions

ThornOfCrowns — Wed, 08 Jul 2015 13:06:27 GMT

Have you tried looking at the Help file?

Re: Functions

crusader_ — Wed, 08 Jul 2015 13:10:14 GMT

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