Strange Data Load issue

[Anonymous]

Hi All,

  I am facing some strange data issue in the Qlik application between the environments(DEV,QA&Prod) .

My scenario is like below

The Forecast table having a date (Fore_Cast_Date) field like "2017-08-09*",'2017-08-10',"2017-09-09*"..etc

As per requirement I need to create a report that  contains " * " should be in one report and excluding " * " in other report.

Also I need to show only last 30 months of Fore_Cast_Date (which has "*") . So I am using below condition

where LEN(Fore_Cast_Date)>10 AND Fore_Cast_Date>=addmonths(PURGECHAR(Fore_Cast_Date,'*'),-30).

Which works fine in Dev & QA environemnt. But it is returning 0 records in Prod environment.

Any idea about the above issue? Let me know if you have more info.

[marcus_sommer]

It's recommended to use only pure numeric values for any kind of matchings/calculations to avoid each potentially trouble with formattings. In your case it would mean just to add another numeric date-field to your loadings/datamodels and using the formatted ones only for displaying within the UI.

- Marcus