topic Re: Set Analysis in QlikView

Set Analysis

Thu, 11 Jul 2013 07:10:18 GMT

Hi All,

May I get some help to write the below mentioned Set Analysis code in better way?

Thanks in advance!

If(ReasonAna='Grand Total',(Count({$<[Service Delay]={1}>}INCIDENT_NO) or Count({$<[Spare Delay]={1}>}INCIDENT_NO) or Count({$<[Engineer Skill Set]={1}>}INCIDENT_NO) or Count({$<[Helpdesk Issue]={1}>}INCIDENT_NO)))

Re: Set Analysis

Thu, 11 Jul 2013 07:18:17 GMT

Try...

if(GetFieldSelections(ReasonAna)= 'Grand Total',
Count({$<[Service Delay]={1}>}INCIDENT_NO)

or Count({$<[Spare Delay]={1}>}INCIDENT_NO)
or Count({$<[Engineer Skill Set]={1}>}INCIDENT_NO)
or Count({$<[Helpdesk Issue]={1}>}INCIDENT_NO)
,

""Default"")

Re: Set Analysis

Sokkorn — Thu, 11 Jul 2013 07:20:21 GMT

Hi,

Try this:

If(ReasonAna='Grand Total',

Count({$<[Service Delay]={1}>+<[Spare Delay]={1}>+<[Engineer Skill Set]={1}>+<[Helpdesk Issue]={1}>} [INCIDENT_NO])

)

Regards,

Sokkorn

Re: Set Analysis

kumarnatarajan — Thu, 11 Jul 2013 07:26:04 GMT

Hi,

try this.

Ex:

=If(ReasonAna='Grand Total',

Count(

{$<[Service Delay]={1}> + <[Spare Delay]={1}> + <[Engineer Skill Set]={1}> + <[Helpdesk Issue]={1}>} INCIDENT_NO))