Hello, I have problem with date format. These dates are from one sheet, where is the same format for all cells, but in Qlik are two formats, via picture... It is a table with two column dimensions and I need sort fail description by repair date. Formula in DATE dimension is the same as in title of second column. Duplicate rows are not problem.
Although you have got what you wanted by doing this on the front end, I would still suggest to fix the dates in the back end script. It is advised to keep front end dimensions to minimum manipulation and something as important as date should be fixed in the script because they are usually used in various places (set analysis and dimensions). Just wanted to give me additional 2 cents .