topic Alphanumeric field formatting in QlikView

Alphanumeric field formatting

Thu, 01 Oct 2015 22:23:49 GMT

We have a field that we download that contains Credit Limit information. It is alphnumeric as we have some customers with credit limits CAD, HOLD, TT, LIA etc.

I would like to format the numerical credit limits appropriately #,## so the comma separator shows up but also keep the data that is alpha

I tried a formula like : if(LIMIT>0, num(LIMIT,#,##), LIMIT)

but this just make the alpha entries blank.

Re: Alphanumeric field formatting

anlonghi2 — Thu, 01 Oct 2015 22:32:23 GMT

Hi Cam,

try with the following formula:

if(isnum(LIMIT), num(LIMIT,'#,##'), LIMIT)

Best regards

Andrea

Re: Alphanumeric field formatting

Thu, 01 Oct 2015 22:48:12 GMT

Gracias!