topic Re: Create a field from two existing field in script in QlikView

Create a field from two existing field in script

lessassy — Wed, 25 Nov 2020 16:16:04 GMT

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 — Tue, 07 Aug 2018 09:50:21 GMT

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 — Tue, 07 Aug 2018 09:59:55 GMT

Ok here is the sample

of the application.

Thank you

pooja_prabhu_n — Tue, 07 Aug 2018 11:59:20 GMT

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;