Date( Date#( INVOICEDATE, 'YYYYMMDD'), 'YYYYMMDD') as SALEDATE,
NUMBER,
CUSTOMERID;
SQL SELECT *
FROM ********************************************";
Inovide date is in string format hence to create master calander from it, i need to convert and manipulate the field. I know the manipulation part however when i try to include in the above statement it gives me field not found error.
also when i include SALES_HISTORY: table into master calander it gives me error SALEDATE not recognized.
UNDERSTANDING:
Once you load the field into Qlikvie via LOAD command. Can that field be manipulated right after. Or is it only available after the FROM statement conculdes and you need to call the field again. This is confusing me.
See the attached file; I initially thought your problem was in the conversion to date... That is basically what my QVW does...
Date#() is used for text to date...
Date returns it into a right format (the one you explicitly specify, or when the 2nd argument misses, the "default" notation on the main-tab of your load script.
The field not found error: it is important that the field SALESDATE is a field in your SQL select statement. Note that Qlikview is case-sensitive, so SaLESDATE is a mismatch, resulting in your error message.
So the upper-part (load ...,...,... (fieldnames) is Qlikview-side: you can immediately do manipulations using Qlikview functions...
the lowerpart (SQL SELECT * FROM) is the part that Qlikview does not interpret, but is interpreted by your database-server, so you can use the functions supported by your dbserver
See the attached file; I initially thought your problem was in the conversion to date... That is basically what my QVW does...
Date#() is used for text to date...
Date returns it into a right format (the one you explicitly specify, or when the 2nd argument misses, the "default" notation on the main-tab of your load script.
The field not found error: it is important that the field SALESDATE is a field in your SQL select statement. Note that Qlikview is case-sensitive, so SaLESDATE is a mismatch, resulting in your error message.
So the upper-part (load ...,...,... (fieldnames) is Qlikview-side: you can immediately do manipulations using Qlikview functions...
the lowerpart (SQL SELECT * FROM) is the part that Qlikview does not interpret, but is interpreted by your database-server, so you can use the functions supported by your dbserver
