topic Re: Dynamic charts in QlikView

Dynamic charts

sayhi2mallik — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Dynamic charts

Shubham_Deshmukh — Fri, 22 Mar 2019 13:00:22 GMT

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

Re: Dynamic charts

Vegar — Fri, 22 Mar 2019 22:55:57 GMT

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

Re: Dynamic charts

Shubham_Deshmukh — Mon, 25 Mar 2019 06:19:08 GMT

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.