topic Current Grade-Previous Grade in QlikView

Current Grade-Previous Grade

Wed, 13 Mar 2013 16:05:56 GMT

Hi experts,

Can any one please let me know how to accomplish my requirement..

each employee is given a grade (from 1 to 12), I need to show the % change in grade by month in bar graph.

(count of employeess from current grade-

count of employeess from previous grade)/count of employeess from previous grade

any help is highly appreciated..

Re: Current Grade-Previous Grade

sushil353 — Wed, 13 Mar 2013 16:22:49 GMT

can u upload sample data

Re: Current Grade-Previous Grade

neha_shirsath — Wed, 13 Mar 2013 17:17:50 GMT

Hi,

Try this expression-

For Current Grade:

Count({<Grade= {$(=max(Grade))}>}Employee)

For Previous Grade:

Count({<Grade= {$(= max(Grade-1))}>}Employee)

Hope it will help you.

Regards,

Neha

Re: Current Grade-Previous Grade

udit_kumar_sana — Wed, 13 Mar 2013 17:42:12 GMT

Hi,

Here you can try like this for month wise % change:

(count({<month>}emloyess current grade)-count({<month>}emloyess previous grade))/count({<month>}emloyess previous grade)

Regards,

Udit

Re: Current Grade-Previous Grade

Wed, 13 Mar 2013 18:25:12 GMT

Hi Neha,

Thanks for the response.

The previous grade can be any grade need not -1

Re: Current Grade-Previous Grade

Wed, 13 Mar 2013 18:25:56 GMT

Hi Udit,

thanks for the response I don't have any column that identifies it is current grade and previous grade

Re: Current Grade-Previous Grade

udit_kumar_sana — Thu, 14 Mar 2013 03:57:20 GMT

Hey,

You can try like this also,

create two alternate states as grp1 & grp2 by going in Document properties,in General tab you have alternate state option.

Create two list boxes of grades,one with grp1 state & other with grp2 state by assiging include exclude value in search option with this grp1 & grp2 states .

Know you can compare the grades with each other from this two list boxes.

Write the below expression in chart for % change month wise .

(count({<grp1,month>}emloyess current grade)-count({<grp2,month>}emloyess previous grade))/count({<grp2,month>}emloyess previous grade)

Regards,

Udit

Re: Current Grade-Previous Grade

udit_kumar_sana — Thu, 14 Mar 2013 04:03:18 GMT

Hey,

One change ,in list boxes assign states in alternate search field provided not in include exclude value option.

Regards,

Udit