Functions are only working in first part of csv file
I uploaded two csv files that represent sales for the months of April and May with exactly the same columns. I imported them using the automatic uploader, not the scripting one. As I have read in the documentation of qlik sense, if you upload 2 or more files with the same columns, qlik concatenates them automatically.
Now, I created a master dimension named month and executed the expression =Month(Date(Date, 'MM/DD/YYYY')) so that I could extract only the month of each transaction. The problem is, only the month of April is affected by this expression.