Create a field from two existing field in script

[lessassy]

Hello everyone,

I had originally a bar chart

with a dimension weekyear and a formula like this :

if(sum(LossBU)/ Count ( {<Breakdown={'Yes'}>} Breakdown)>0,sum(LossBU)/ Count ( {<Breakdown={'Yes'}>} Breakdown),0)

But I want to include that formula in the script  as MTTR because i want it to be a part of a table box

I already tried this

MTTR:

LOAD

LossBU,

Breakdown,

(sum(LossBU)/ Count ( Breakdown=('Yes'))) as MTTR

But it didn't work

I think becasue the 'yes' is include in the field and qlikview don't recognize it

Thank you in advance

[kfoudhaily]

set analysis shouldn't work on script;

it could be replaced with a group by depending on the case.

can you please provide sample qvw to have a look at data model?

regards,

[lessassy]

Ok here is the sample

of the application.

Thank you

[pooja_prabhu_n]

Hi,

you can try like this

T1:

LOAD * INLINE [

BreakDown,LossBU, Year

No, 0, 2018

Yes, 95, 2018

Yes, 60, 2018

];

T2:

LOAD sum(LossBU)/Count(if(BreakDown='Yes',BreakDown)) as MTTR,

Year

Resident T1

Group By Year;