Set analysis equation question

Anonymous — Tue, 03 Feb 2015 20:31:50 GMT

Morning all

I have an issue with an equation that is working fine when I use it in a text box but seems to be ignoring the set anlysis when I use it in a bar chart.

Equations:

% of total jobs

=(sum(if(len([Completed Date])>0,#ACTION_COUNTER,0)))/(sum({1<[Property Status]={Active}>}if(len([Completed Date])>0,#ACTION_COUNTER,0)))

%of late jobs

=(sum(if([Resolution flag]='Target Missed',1,0))/(sum(if(len([Completed Date])>0,#ACTION_COUNTER,0))))

Weighted % = % of total jobs * % of late jobs

=((sum(if(len([Completed Date])>0,#ACTION_COUNTER,0)))/(sum({1<[Property Status]={Active}>}if(len([Completed Date])>0,#ACTION_COUNTER,0))))*((sum(if([Resolution flag]='Target Missed',1,0))/(sum(if(len([Completed Date])>0,#ACTION_COUNTER,0)))))

when I use Weighted % in a bar chart I get

Re: Set analysis equation question

Tue, 03 Feb 2015 21:25:13 GMT

Hi,

it's possible to have date or qvw?

beacause it's so difficult to help you

Julien

Re: Set analysis equation question

Anonymous — Wed, 04 Feb 2015 00:28:15 GMT

Sample data attached

topic Set analysis equation question in QlikView

Set analysis equation question

Re: Set analysis equation question

Re: Set analysis equation question