Discussion Board for collaboration on QlikView Layout & Visualizations.
Hi to all
Need help, somehow i am getting field on layout different from original data.
How can i show the exact field?
Go to Solution.
Do you want to preserve the exact number of leading zeroes? Then do this:
LOAD text(Field) As Field,
Len(..... rest of your SQL expression ....
try it once in text object
by using same expression
Try num(Field, '0000')
Paste the code above the sql statement.
Num(Field) as New;
Num' is not a recognized built-in function name.
SQL##f - SqlState: 37000, ErrorCode: 195, ErrorMsg: [Microsoft][ODBC SQL Server Driver][SQL Server]'Num' is not a recognized built-in function name.
len(INVENTCOLORID) as Length,
INVENTCOLORID as Field,
Num(INVENTCOLORID) as New
len(INVENTCOLORID) as length,
INVENTCOLORID as Field
text(Field) as Field
Drop tab Tab1;
still the same