Aggr Help!

Mon, 11 Nov 2013 16:26:50 GMT

I have the following formula which allows me to show if a KPI is Red/Amber/Green in a guage - based on;

<1 of the metrics in the KPI group is a Challenge = Green,

>1 metric Challenge = Red,

and 1metric Challenge= Amber

(sum(aggr(if(SummaryActivityDate=date(max(total <MetricKPI> SummaryActivityDate)),sum(Challenges)),MetricKPI,SummaryActivityDate))<1,0.825,
if(sum(aggr(if(SummaryActivityDate=date(max(total <MetricKPI> SummaryActivityDate)),sum(Challenges)),MetricKPI,SummaryActivityDate))>1,0.165,
if(sum(aggr(if(SummaryActivityDate=date(max(total <MetricKPI> SummaryActivityDate)),sum(Challenges)),MetricKPI,SummaryActivityDate))=1,0.5,0.825)))
)

I am now needing this formula amending so I can run a mini bar chart with the red amber green (where red =1, Amber = 2 and Green = 3) for a 15 month period but Im struggling to do this.

The data appears to roll up to KPI level or Month level so it isnt correct pls help

Re: Aggr Help!

Anonymous — Mon, 11 Nov 2013 20:16:11 GMT

Hi joanne,

Can you please explain briefly with example or any images,i am not getting your question.

Thanks

Re: Aggr Help!

Mon, 11 Nov 2013 20:38:18 GMT

Please post sample qvw.

topic Re: Aggr Help! in QlikView

Aggr Help!

Re: Aggr Help!

Re: Aggr Help!