topic Bar chart expression in QlikView

Bar chart expression

qlikviewwizard — Wed, 15 Apr 2015 03:35:44 GMT

Hi All,

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

mjayachandran — Wed, 15 Apr 2015 04:21:20 GMT

You can try something like attached

robert_mika — Wed, 15 Apr 2015 04:21:29 GMT

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 — Wed, 15 Apr 2015 04:28:02 GMT

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 — Wed, 15 Apr 2015 05:57:34 GMT

Thank you all.