How to integrate a figure if doesn´t come on the load

[#1]

IF I load a table with no data in one column and i want that by default if the column has no data pint for me a numer... How i can do it?

[#2]

doesn´t run i tried on script and on the visualization mode and no results.

Any other idea?

[MarcoWedel]

Hi,

one example using some of the already proposed expressions as well as the RangeSum() function I would like to add to the possible solutions:

LOAD Kind,
    Item,
    Units,
    If(Len(Trim(Units)),Units,0) as UnitsLenTrim,
    If(Len(Units)>0,Units,0) as UnitsLen,
    Alt(Num(Units),0) as UnitsAlt,
    RangeSum(Units) as UnitsRangeSum
FROM [https://community.qlik.com/thread/249798] (html, codepage is 1252, embedded labels, table is @1);

If you could post a sample of your application we might be able to identify the reason why your script fails:

Preparing examples for Upload - Reduction and Data Scrambling

hope this helps

regards

Marco