expression

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

HI all i want to get the output in minutes for the below expression can somone please suggest me

sum(TimetoExecute)/count({<Almrun_masterPriority={1,2,3}>}Almrun_masterTestcsName)

and two digit percentage for below expression

=count( aggr (max(RunDate),Almrun_masterTestcsName,Almrun_masterTestcsName))/count({<Almrun_masterPriority={1,2,3}>}Almrun_masterTestcsName)

How to include max(rundate) into below expression set analysis

sum({<Almrun_masterPriority={1,2,3}

>}TimetoExecute)

thanks in advance.....

Re: expression

Anil_Babu_Samineni — Thu, 17 Aug 2017 11:04:37 GMT

May be this?

Num((count( aggr (max(RunDate),Almrun_masterTestcsName,Almrun_masterTestcsName))/count({<Almrun_masterPriority={1,2,3}>}Almrun_masterTestcsName)), '#,#0.00%')

And

sum({<Almrun_masterPriority={1,2,3}, rundate={'$(=Max(rundate))'}>}TimetoExecute)

topic expression in QlikView

expression

Re: expression