topic Num(Registration_CODE, '###0') in QlikView

Num(Registration_CODE, '###0')

Tue, 22 Feb 2011 19:26:40 GMT

Can anyone help me understand the function Num(Registration_CODE, '###0') and how it represents the Registration_CODE here. For example, if Registration_CODE is 00253 or 02530 or 25300 or 25345 How will it represent the data? Registration_CODE is text in the source.

Num(Registration_CODE, '###0')

prieper — Tue, 22 Feb 2011 19:36:24 GMT

It treats your text as a number in the given format, i.e. you may have it displayed like 02530, but summarizing, averaging etc will work with 2530.

HTH
Peter

Num(Registration_CODE, '###0')

Tue, 22 Feb 2011 21:21:32 GMT

What if I am matching Registration_CODE from one table to another? One table has preceding zero and other table coming from excel doesn't have preceding zero? Is it still going to match or I've to do some transformation to one or the other source field?

Num(Registration_CODE, '###0')

prieper — Tue, 22 Feb 2011 21:30:11 GMT

Not sure, but think that QV is tolerant in this respect - see the attached.

Table2:
 LOAD
 *
 INLINE
 [RegCode, Val2
 12, 13
 45, 14
 A14, 15
 56, 13];
Table1:
 LOAD
 *
 INLINE
 [RegCode, Val
 00012, 3
 00045, 4
 A14, 5
 56, 3];

Remark: Copy Table1 before Table2 would result in RegCode to be displayed as 00012, etc.

HTH
Peter