Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Chanty4u
MVP
MVP

RE:What wrong inmy expo?

Hi all,

,jagan mohan rao appala,Tamil Nagaraj,,Sunny T ,Sunny k ,settu_periasamy,swuehl

i want to caluculate

1.for each exe_testId get latest exc_rundate

2.for the ex_testid and latest exc_rundate and get the exc_status

3.If exe_status ='not passed'  then count.

here is my exp

=Count

  (DISTINCT if(not IsNull(

  if(Aggr

  ( NODISTINCT

  Max({<Exec_Status  -= {'Passed'}>} Exec_RunDate)

  ,

  lvl_id, Exec_TestID

  )

  < Now()

  , Exec_TestID

  )

  )

  , Exec_TestID)

  )

can anyone help me on this?

thanks

Suresh

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

Hi,

Try this expression

=Sum(Aggr(Count({<Exec_RunDate={"<=$(=Date(Today(), 'YYYY-MM-DD'))"}>}DISTINCT Exec_TestID), lvl_id))

Regards,

jagan.

View solution in original post

33 Replies
Anonymous
Not applicable

COUNT{exe_status ={'not passed'}(exe_testId)

TO GIVE THE EACH DIMENSION

Anonymous
Not applicable

Now() will return Timestamp

Try like Date(Now(),'YourFormat')

Anonymous
Not applicable

may be like this?

=Count(DISTINCT if(not IsNull(

  if(Aggr( NODISTINCT Max({<Exec_Status  -= {'Passed'}>} Exec_RunDate) ,Exec_TestID )  < Date(Now(),'Exec_RundateFormat')

  , Exec_TestID)), Exec_TestID) )

Chanty4u
MVP
MVP
Author

no luckbalraj...

Anonymous
Not applicable

1.for each exe_testId get latest exc_rundate

2.for the ex_testid and latest exc_rundate and get the exc_status

3.If exe_status ='not passed'  then count.

=aggr(max(exc_rundate), exe_testId)    //For 1st

=if(exe_status ='not passed', count(Exec_TestID)  // For 3rd

What you want from the 2nd point? How do you want to compare exe_status & exc_rundate??

2.for the ex_testid and latest exc_rundate and get the exc_status





Try like this?

=count(aggr(max({<exe_status={'*'} - {'Passed'} >}exc_rundate), exe_testId) distinct exe_testId)

sasikanth
Master
Master

HI,

Try this

Count

  (DISTINCT if(not IsNull(

  if(Aggr

  ( NODISTINCT

  Max({<Exec_Status  ={'*'}- {'Passed'}>} Exec_RunDate)

  ,

  lvl_id, Exec_TestID ) , Exec_TestID )

  )

  , Exec_TestID)

  )

Chanty4u
MVP
MVP
Author

not working sunny  and balraj

sasikanth
Master
Master

Any sample data or your app?

Chanty4u
MVP
MVP
Author

my req is

Count of Exec_Status in 'Not Passed' status, this should be extracted based on System date