Bar chart expression

[qlikviewwizard]

Hi All,

I want to show the Marks Categories,No of Students,Percentage values in a bar chart for the below table data.

EMPNO	ENAME	MARKS
7369	SMITH	35
7499	ALLEN	45
7521	WARD	89
7566	JONES	65
7654	MARTIN	76
7698	BLAKE	63
7782	CLARK	98
7788	SCOTT	95
7839	KING	41
7844	TURNER	53
7876	ADAMS	87
7900	JAMES	88
7902	FORD	92
7934	MILLER	56
Marks Category	No of Students	Persontage
Below 40%	x	x
40%-60%	x	x
60% to 70%	x	x
Above 70%	x	x
Total	x	x

[mjayachandran · Accepted solution]

You can try something like attached

[robert_mika]

Create Calculated Dimension

=If(MARKS<40,'Below 40%',if(MARKS>=40 and MARKS<60,'40%-60%',if(MARKS>60 and MARKS <=70,'60% to 70%',if(MARKS >70,'Above 70%',0))))

Then Expression

Count(EMPNO)

Count(MARKS)/count(TOTAL MARKS)

[robert_mika]

Or you can create this in Script:

Directory;

LOAD EMPNO,

     ENAME,

     MARKS,

     If(MARKS<40,'Below 40%',if(MARKS>=40 and MARKS<60,'40%-60%',if(MARKS>60 and MARKS <=70,'60% to 70%',if(MARKS >70,'Above 70%',0))))as Category

FROM

and the use Category as Dimension

To get the Total in Dimension Limit choose Show Total

[qlikviewwizard]

Thank you all.