Value count of Excel based table data?

[#1]

Hi, I am new to QV and need some help. How can I create a table of courses attended by employee from an excel source where attendance is indicated by a Yes/No value at the employee-course intersection? Rows are person, columns are courses.

Any help would be appreciated!

Thanks

[MK_QSL]

=count({<attendance = {'Yes'}>} cources)

[#3]

u can do this in backend scripting  also

in scripting you can use IF Clause to calculate

or in table /Chart

=Count({$<Attendance={'Yes'}>}Courses)

[aveeeeeee7en]

Hi Eugene Blouin

Please go see the Attached Qvw.

Hope it works for you.

Regards

Aviral Nag

[#5]

HI - I cannot download the file you sent. I get a message re: too many dowloads.

I did recieve seeral other answers though

Thanks!

[#6]

Thanks!

[aveeeeeee7en]

PFA.

Try Now.

[#8]

Hi,

Still cannot open on my Personal license. I get the same message as before. I appreciate your attempt to help.

[aveeeeeee7en]

It will not run on your  your Personal Edition.

Follow these steps:

1)  Copy this code in your Edit script:

[Data]:

CrossTable(Courses, Attendance, 1)

LOAD * INLINE [

Person,    Qlikview Certification,    Graphic Designer,    SAP-BI,    IT Analyst,    Business Analyst

Alex,            Yes          ,      Yes      ,    Yes  ,    Yes  ,      No

Ron,            No          ,      No        ,    No  ,    No    ,      Yes

Jack,            No          ,      No        ,    Yes  ,    No    ,      No

Mathew,          Yes          ,      Yes      ,    No  ,    No    ,      Yes

jason,          Yes          ,      No        ,    Yes  ,    Yes  ,      Yes

Hugh,            No          ,      Yes      ,    Yes  ,    No    ,      No

];

2) Reload the Script.

3) Create Pivot Table.

4) Add Dimensions: a) Person b) Attendance

  Write Expression: Count(DISTINCT Courses).

5) Drag Attendance Field on Top of the Expression. You will see the Yes & No as Columns and their Count as Rows. See the Attached Image for it@(Pivot Table Design).

6) Else you can create Table Box in respect of Pivot Table and Add all Dimensions in it. See the Attached Image for it(Table Box).