Hi Dojo,
In my LCA, I am trying to sort a table by column. Using the "sort" and "then sort by" operators in the CQI, I have sorted five columns, but the result is not as expected. Only the first column is sorted correctly; the others are sorted randomly. How is this possible? How can I fix the table?
Thank you.
The results in the table are not sorted as described in the query. The results are sorted only by the first sort condition. Then the rows are sorted randomly. The columns "Data" and "Ora" are not sorted as requested by the query as you can see in the picture
Hi Marco,
A possible explanation for the sorting could be that the raw values of the cells do not match the display values. Since GQI uses the raw value to sort, there can be some mismatch here. An easy way to check this is to use the 'More' menu on the top right of the table and export a CSV with display values and one with raw values. If the values in the files do not match and the raw values are also sorted incorrectly, we will have to look into this further.
The two CSV are identical and the one withe the raw value don't have the right sorting. :((
In that case we will need more info to properly investigate what is going wrong here. Can you contact tech support and give them the details of your issue?
Thank you Wout. Tech support… how? Can you give me please some contact? Thank you
You can email to 'techsupport@skyline.be'
I sent an email to the support. Thank you very much for your quick response!
Hi Marco, Can you add a screenshot or example of the query, your data and how the result looks?