Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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,
Ok here is the sample
of the application.
Thank you
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;