When using the date picker extension and selecting a date field from the data model, no fields are available and a error message that says invalid dimension is shown. Dates in the data model have the correct format that also match with the set regional environmental settings in the script (see Dashboard Bundle Date Picker object does not pick data ranges) yet the Invalid Dimension error message.
Environment:
Resolution
A functioning example statement looks like this:
TAG FIELD TransactionDate WITH '$date';
Load
Date(today()+1) as TransactionDate
Autogenerate 10;
This adds the missing tag to identify the field as a valid date dimension.
This statement can be inserted at any point in the script.
Related Content:
Should you require further assistance, connect with our active Qlik Community for creative application development assistance and ideas, or connect with our support team at support.qlik.com referencing this article ID.