topic Re: Set Analysis in Straight Chart in QlikView

Set Analysis in Straight Chart

Wed, 23 Jul 2014 02:58:54 GMT

Hello,

Can you use the result of a separate object in set analysis for a straight table ?

I want to show the attendees at various seminars as a percentage of total staff. I have the 'Course Name' as the dimension in the straight table and can calculate the count of attendees no problems. I have used the following set analysis for the percentage calc:

=NUM(count({<ATTENDANCE = {'Compulsory'} >} [EMP NO.]) /

count({<[ACT/INACT] = {'A'}>} [EMP NO.]),

'#,##0.0%')

I get a 100% for all courses as I think it is calculating based on the dimension of course name.

How do I get it calculate on total staff, which I have as a separate text object with the following expression (same as in above set analysis):

count({<[ACT/INACT] = {'A'}>} [EMP NO.])

Thanks

Wayne

Re: Set Analysis in Straight Chart

SunilChauhan — Wed, 23 Jul 2014 03:10:24 GMT

NUM(count( {<ATTENDANCE = {'Compulsory'} >} total [EMP NO.]) /

count({<[ACT/INACT] = {'A'}>} total [EMP NO.]),

'#,##0.0%')

Re: Set Analysis in Straight Chart

PrashantSangle — Wed, 23 Jul 2014 04:15:09 GMT

Hi,

Try with TOTAL keyword Like this,

NUM(

count({<ATTENDANCE = {'Compulsory'} >} [EMP NO.])

count({<[ACT/INACT] = {'A'}>} TOTAL [EMP NO.]),

'#,##0.0%')

Regards,

Re: Set Analysis in Straight Chart

Wed, 23 Jul 2014 05:07:28 GMT

Thanks Max,

Simple as that.