Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

bar chart

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

4 Replies
sunny_talwar

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

];

Capture.PNG

Chanty4u
MVP
MVP

Anonymous
Not applicable
Author

‌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

May be add an inline table with all possible score:

LOAD * Inline [

Score

1

2

3

4

5

6

7

8

9

];

Table:

CrossTable(Subject, Score)

LOAD * Inline [

student, Sub1, sub2, sub3

stud1,    6,    5,    8

stud2,    4,    6,    9

stud3,    8,    3,    1

];

Capture.PNG