5 Replies Latest reply: Aug 2, 2016 9:52 PM by Maiko Francisco Rugeria RSS

    Functions are only working in first part of csv file

    Maiko Francisco Rugeria

      Hi!

       

      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.

       

      Any ideas about the problem?

       

      Note: Date is timestamp

      Screenshot from 2016-08-02 16:24:27.png