topic Re: Re: Value count of Excel based table data? in QlikView

Value count of Excel based table data?

Sun, 16 Feb 2014 10:13:24 GMT

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

Re: Value count of Excel based table data?

MK_QSL — Sun, 16 Feb 2014 10:19:20 GMT

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

Re: Value count of Excel based table data?

Sun, 16 Feb 2014 10:24:36 GMT

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)

Re: Value count of Excel based table data?

aveeeeeee7en — Sun, 16 Feb 2014 10:47:59 GMT

Hi Eugene Blouin

Please go see the Attached Qvw.

Hope it works for you.

Regards

Aviral Nag

Re: Value count of Excel based table data?

Sun, 16 Feb 2014 11:39:00 GMT

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

I did recieve seeral other answers though

Thanks!

Re: Value count of Excel based table data?

Sun, 16 Feb 2014 11:39:35 GMT

Thanks!

Re: Re: Value count of Excel based table data?

aveeeeeee7en — Sun, 16 Feb 2014 11:46:38 GMT

PFA.

Try Now.

Re: Re: Value count of Excel based table data?

Sun, 16 Feb 2014 11:50:06 GMT

Hi,

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

Re: Re: Re: Value count of Excel based table data?

aveeeeeee7en — Sun, 16 Feb 2014 12:03:52 GMT

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).