I am very new to Qlik sense, my task is to modify the table in such a way that in the comments section only the recent comment is visible and on hovering on it more comments are visible which are separated by comma but not all comments are visible as there is a lot of text in one cell.
I have to find a solution though which the user is able to see all the comments using a drill down or any other way.
If you go to the styling of the table properties there are things you can do to change font size and the like to try and show a bit more text.
If you have a lot though what you should look at doing is having a text object which shows the detailed comment when only one record is selected. It sounds like your table is correct, add the Text & Image component with a single expression added, reading like this:
=if(GetPossibleCount(Comment) = 1, Only(Comment), 'Please select a row with a single comment to view details')
You could add more details to the second part of the if, if you wanted for instance:
'There are ' & GetPossibleCount(Comment) & ' comments. Please select one to view.'
If you want to have the display more dynamic, you could perhaps go for a Tab Containerwhich contains both the table and the text box and then toggle tabs with a Show Conditions of:
