Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
sayhi2mallik
Contributor
Contributor

Dynamic charts

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.

3 Replies
Shubham_Deshmukh
Specialist
Specialist

Just go through what is CrossTable in Qlikview, you will get idea about it.
Vegar
MVP
MVP

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)

Good luck
Vegar
Shubham_Deshmukh
Specialist
Specialist

Hey @Vegar ,

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.