topic Re: restricting the values in QlikView

restricting the values

ssriramin19 — Mon, 26 Jan 2026 18:19:17 GMT

Hello,

My question is that I have a field called corp_grp_code which has the values as 0000000002 and 0000000001.But my requirement is that instead of full digists only single digit 1 and 2 should need to be displayed.

Can anyone help me on this .

Thanks

Sriram

Re: restricting the values

tresB — Tue, 15 Oct 2013 06:11:22 GMT

Use Num() function

Re: restricting the values

vivek_niti — Tue, 15 Oct 2013 06:11:52 GMT

Hi,

Use the Num() function on corp_grp_code. That will remove the leading zeros.

Thanxs,

Vivek

Re: restricting the values

Tue, 15 Oct 2013 06:11:57 GMT

Which range of values would have that field? Based on your informations I sugest you two solutions:

LOAD NUM(corp_grp_code) AS corp_grp_code_new

RESIDENT Table;

This one is for 1 digit value range field:

LOAD right(corp_grp_code,1) as corp_grp_code_new

RESIDENT Table;

Could you be more specific on the exact problem?

Re: restricting the values

CELAMBARASAN — Tue, 15 Oct 2013 06:46:33 GMT

Hi,

If the value is in text format then u could use below

=Num(Num#(FieldName, '#'))

if not simply use Num()

Re: restricting the values

Tue, 15 Oct 2013 07:07:26 GMT

Use the Num() Function. It will help you achieve your target.

Re: restricting the values

Tue, 15 Oct 2013 07:40:01 GMT

Hi,

Num() is just a format function.

If you want to store your data without zeros, use LTrim(corp_grp_code)*1 in your load script.