Discussion Board for collaboration related to QlikView App Development.
Need a small help.
I have a table. I would to insert a column and the value of this column has to be NA
May I know if this is possible.
Column 1 Column 2 Need Column 3
A 1 NA
B 2 NA
C 3 NA
D 4 NA
If it's just as simple as showing it in a table, without having any logic attached, create a Straight table with Column1 and Column2, then add an Expression 'NA' with Column3 as label.
No loading or scripting required.
View solution in original post
Are you trying to do this in the script??? If yes then you can do like this:
LOAD [Column 1]
'NA' as NeedColumn3
Try like this
Load *,'N/A' as Col3;
load * Inline
No. I have data with Column 1 and Column 2.
I have imported this data inside QlikView. But I want a to have a Column 3 and it should say NA (NA is not the heading) the data for Column 3.
NA isn't a heading it will be data within your third column.
LOAD * INLINE [
3, Ban, c
Load *,'NA' as Col3 Resident TempTabA;
Drop Table TempTabA;
You mean Resident TempTabA:
Thanks guys.. I used an expression as NA for Column 3