Loading Non Standard Numeric Signs

Filename Loading-Non-Standard-Numeric-Signs.qvw
Filesize 503 KB
version 1 - QlikView
1 - Qlik Sense Previous versions
Date added Dec 6, 2019
Downloaded 75 times
Category Scripting

This receipe demonstrates how to read numbers that have non-standard number signing formats, for example a trailing “-” to indicate negative numbers or a keyword like “DEBIT”.

    102-
    400 DEBIT

Both should be interpreted as negative numbers.

    -102
    -400

 

Recipes for Qlikview Success