Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Chanty4u
Esteemed Contributor III

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
Highlighted
MVP & Luminary
MVP & Luminary

Re: RE:What wrong inmy expo?

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
Highlighted
vsudhakar
Contributor III

Re: RE:What wrong inmy expo?

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

TO GIVE THE EACH DIMENSION

Highlighted
balrajahlawat
Esteemed Contributor

Re: RE:What wrong inmy expo?

Now() will return Timestamp

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

Highlighted
balrajahlawat
Esteemed Contributor

Re: RE:What wrong inmy expo?

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

Highlighted
Chanty4u
Esteemed Contributor III

Re: RE:What wrong inmy expo?

no luckbalraj...

Highlighted
balrajahlawat
Esteemed Contributor

Re: RE:What wrong inmy expo?

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)

Highlighted
sasikanth
Valued Contributor III

Re: RE:What wrong inmy expo?

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)

  )

Highlighted
Chanty4u
Esteemed Contributor III

Re: RE:What wrong inmy expo?

not working sunny  and balraj

Highlighted
sasikanth
Valued Contributor III

Re: RE:What wrong inmy expo?

Any sample data or your app?

Highlighted
Chanty4u
Esteemed Contributor III

Re: RE:What wrong inmy expo?

my req is

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