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

func

HI all can somone please correct the below expression ?

=count( aggr (max(RunDate),[Test Case Name]))

Thanks in advace

1 Solution

Accepted Solutions
Anil_Babu_Samineni

Expression is correct only?

Why do need 2 times fields in your expression, This should work

count( aggr (max(RunDate),[Test Case Name]))

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

6 Replies
Anonymous
Not applicable

... you need to post a sample and elaborate a bit more...

devarasu07
Master II
Master II

Hi,

like this?

Count(Aggr(NODISTINCT max(RunDate),[Test Case Name]))

or

Max(Aggr(count(RunDate),[Test Case Name]))

its_anandrjs

Provide sample data or else you can copy paste this script on the text box or any chart to have a look the effect of the expression.

Regards

Anand

smilingjohn
Specialist
Specialist
Author

IAm using below epression

count( aggr (max(RunDate),[Test Case Name],[Test Case Name]))

is this correct

Anil_Babu_Samineni

Expression is correct only?

Why do need 2 times fields in your expression, This should work

count( aggr (max(RunDate),[Test Case Name]))

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
its_anandrjs

This seems working count( aggr (max(RunDate),[Test Case Name],[Test Case Name])) but check your end.


Regards

Anand