Discussion Board for collaboration related to QlikView App Development.
I had loaded a table into qlikview from a select query. While loading I have synthesized new fields from the existing fields of the table.
For eg:- Month(slice_date) Filled_Month.
salary+100 Increment_Sal. etc., wher slice_date,salary are the existing fields of the source table.
Now during the same load I intend to create few more fields like for eg:-
Num(Filled_Month) MonthNum etc,.
Can I do like this. If I can't do like this, then I need to once again write like below,
Num(Month(slice_date)) MonthNum etc,
Quite did not get your question, but Yes you can create few more fields.
Can you attach the sample app for the same?
You can't reference a field that you create in a Load statement within the same Load statement.
For example if you create your Filled_Month statement, you can't use Filled_Month as input for a new field in the same load statement.
The easiest way to reference it is to add a preceding Load statement. This will allow you to reference the Filled_Month field.
XYZ + 1 as ABC;
1 as XYZ
Try like this
Month(slice_date) AS Filled_Month,
(salary+100) AS Increment_Sal,