Discussion Board for collaboration related to QlikView App Development.
I am using the following script in order to create a date from a time stamp:
Week(Transaction_Date) as Semaine,
Year(Transaction_Date) as Année,
This script works fine to get my Transaction_Date; but when I add the last 2 lines in order to get the week and year of this date, the script stops with the statement that "Transaction_Date field connot be found or does not exists".
Any idea for sorting out this issue???
Thanks in advance.
Try like this
Year(Transaction_Date) as Année;
View solution in original post
The script is now working. Thanks a lot.
I just need to check my data integrity as I have quite a number of lines with missing dates.
Anyway thank you very much that pushing me a step forward!!!