Discussion Board for collaboration related to QlikView Deployment.
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 .
Go to Solution.
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
This one is for 1 digit value range field:
LOAD right(corp_grp_code,1) as corp_grp_code_new
Could you be more specific on the exact problem?
Use Num() function
Use the Num() function on corp_grp_code. That will remove the leading zeros.
If the value is in text format then u could use below
if not simply use Num()
Use the Num() Function. It will help you achieve your target.
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.