Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am new to QlikSense. I loaded CSV files from MarkLogic. There is only one CSV file in data model . I wanted to do a Preceding Load . I wanted to see Year , Month of [Date Paid ] field. I wrote the code but it is coming blank. Please suggest.
Try this instead of [Date Paid] = [Date Paid] in your load script
Date#([Date Paid],'YYYY/MM/DD') as [Date Paid]
DatePaid is probably being loaded as a string. You need to convert to a date before functions like Year(), Month() will work. Use the Date# function as described above, or like this:
Date(Date#([Date Paid],'YYYY/MM/DD')) as [Date Paid]