topic bar chart in QlikView

bar chart

Anonymous — Wed, 30 Mar 2016 09:05:23 GMT

HI friends,

i have a table with four columns student, subject1, subject2, subject3 for every student a grade is given 1 is min and 10 max

sample dataset

student. Sub1 sub2 sub3

stUd1. 6. 5. 8

stud2. 4. 6. 9

stud3. 8. 3. 1

soon

now i want a bar chart

denmension as grade 1 to 10 (im using valueloop (1,10,1)

in expression i want the count like number of grade 1, count of grade 2 soon

please write the expression in the post i have a qlikview personal edition

sunny_talwar — Wed, 30 Mar 2016 09:09:16 GMT

May be try with CrossTable Load:

Table:

CrossTable(Subject, Score)

LOAD * Inline [

student, Sub1, sub2, sub3

stud1, 6, 5, 8

stud2, 4, 6, 9

stud3, 8, 3, 1

];

Chanty4u — Wed, 30 Mar 2016 09:10:40 GMT

may be this

Anonymous — Wed, 30 Mar 2016 09:12:19 GMT

‌thanks sunny. But i want to show other grade as well in the bar chart which is missing in dataset like 2,7 and 10

sunny_talwar — Wed, 30 Mar 2016 09:15:04 GMT

May be add an inline table with all possible score:

LOAD * Inline [

Score

];

Table:

CrossTable(Subject, Score)

LOAD * Inline [

student, Sub1, sub2, sub3

stud1, 6, 5, 8

stud2, 4, 6, 9

stud3, 8, 3, 1

];