Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I am having this weird issue and unable to understand why.
I am having a csv like:
Date | UserEmail | RecoverableSize | MFADaysAgo |
9/16/2021 | abc@gmail.com | 51.9598 | 1 |
I checked in the csv, date is considered as date and when I am loading it on qliksense, with simple statment "Date" as "Report Creation Date" , it is able to process in the charts like Fig1.
Also see the change in format of csv and qliksense..from mm/dd/yyyy to mm-dd-yyyy
However, when I am using max function on recoverable size using latest date. It is not showing nothing.
so I tried changing the date format....Whenever I am loading the date with any changes ..like Date(Date#("Date",'MM/DD/YYYY'),'MM/DD/YYYY') AS "Report Creation Date", script successfully runs but nothing is processed.
Can someone please help and tell me what's happening.
Can you share sample data??
or share you script
To check the format of the date open that csv in notepad. then you will see actual format of date
also FYI,
mm -> minutes
MM-> Month
if you are using small letter (mm) then replace it with capital letter (MM)
Regards,
Prashant Sangle