topic Re: func in QlikView

func

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

HI all can somone please correct the below expression ?

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

Thanks in advace

Anonymous — Thu, 17 Aug 2017 07:59:40 GMT

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

devarasu07 — Thu, 17 Aug 2017 08:03:14 GMT

Hi,

like this?

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

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

its_anandrjs — Thu, 17 Aug 2017 08:03:40 GMT

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 — Thu, 17 Aug 2017 09:28:52 GMT

IAm using below epression

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

is this correct

Anil_Babu_Samineni — Thu, 17 Aug 2017 09:32:13 GMT

Expression is correct only?

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

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

its_anandrjs — Thu, 17 Aug 2017 09:36:00 GMT

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

Regards

Anand