Hi, I have student data with scores in 3 subjects for last 3 years. I would like to know the best format to show the data indicating progress of students in each of the subjects in last 3 years. I am not able to load the file to Qlikview, I am not sure whether I have to define the data in different format in excel understandable to Qlikview.
It is true as @Shubham_Deshmukh writes, you should look into the crosstable functionality, but it will not be a simple straight forward handling hence you have two header rows in your table. Consider if it is possible, by simple means, to change to source to a single header pivot. If it is possible then a simple crosstable load will do the trick.
Don't worry if it not possible to make adjustents in the source, it is still doable. I suggest you to do a google search like this: https://www.google.se/search?q=qlikview+cross+table+multiple+header to find the solution you are looking for. (You notice that most of the hits leads you back to this community)
Actually I don't have too much idea about the same, I knew that it would be possible with cross table, so just mentioned the same so that he could get some help at least up to certain extent.
