Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Specialist
Specialist

expression

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.....

1 Solution

Accepted Solutions
Anil_Babu_Samineni

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)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

1 Reply
Anil_Babu_Samineni

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)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful