topic Re: RE:What wrong inmy expo? in QlikView

RE:What wrong inmy expo?

Chanty4u — Wed, 17 Feb 2016 11:18:46 GMT

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

Re: RE:What wrong inmy expo?

Anonymous — Wed, 17 Feb 2016 11:25:33 GMT

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

TO GIVE THE EACH DIMENSION

Re: RE:What wrong inmy expo?

Anonymous — Wed, 17 Feb 2016 11:28:43 GMT

Now() will return Timestamp

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

Re: RE:What wrong inmy expo?

Anonymous — Wed, 17 Feb 2016 11:30:47 GMT

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

Re: RE:What wrong inmy expo?

Chanty4u — Wed, 17 Feb 2016 11:32:59 GMT

no luckbalraj...

Re: RE:What wrong inmy expo?

Anonymous — Wed, 17 Feb 2016 11:38:53 GMT

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)

Re: RE:What wrong inmy expo?

sasikanth — Wed, 17 Feb 2016 11:39:56 GMT

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)

)

Re: RE:What wrong inmy expo?

Chanty4u — Wed, 17 Feb 2016 11:43:03 GMT

not working sunny and balraj

Re: RE:What wrong inmy expo?

sasikanth — Wed, 17 Feb 2016 11:43:47 GMT

Any sample data or your app?

Re: RE:What wrong inmy expo?

Chanty4u — Wed, 17 Feb 2016 11:45:44 GMT

my req is

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

Re: RE:What wrong inmy expo?

Chanty4u — Wed, 17 Feb 2016 11:49:24 GMT

balraj shwng exp error

i hve tried other exp but that is nt gvng exact values

Re: RE:What wrong inmy expo?

sasikanth — Wed, 17 Feb 2016 11:55:21 GMT

HI,

Pls. see the attachment

Re: RE:What wrong inmy expo?

Anonymous — Wed, 17 Feb 2016 11:55:24 GMT

Remove Comma before Distinct

Re: RE:What wrong inmy expo?

Chanty4u — Wed, 17 Feb 2016 11:59:27 GMT

same result sunny...ur expression is shwng Ok. the result is nt getting correct

Re: RE:What wrong inmy expo?

sasikanth — Wed, 17 Feb 2016 12:00:35 GMT

Please share your app

Re: RE:What wrong inmy expo?

tamilarasu — Wed, 17 Feb 2016 12:05:54 GMT

Try like below,

=Count

(DISTINCT if(not IsNull(

if(Aggr

( NODISTINCT Max({<Exec_Status -= {'Passed'}>} Exec_RunDate), lvl_id, Exec_TestID)

< Num(Today(0)), Exec_TestID)

)

, Exec_TestID)

)

Re: RE:What wrong inmy expo?

Chanty4u — Wed, 17 Feb 2016 12:12:07 GMT

no luck..

PFA

my qvw

Re: RE:What wrong inmy expo?

Chanty4u — Wed, 17 Feb 2016 12:12:37 GMT

even its error

Re: RE:What wrong inmy expo?

tamilarasu — Wed, 17 Feb 2016 12:20:22 GMT

Can you post your output of the above expression which i provided you. Im not at my system now.

Re: RE:What wrong inmy expo?

Chanty4u — Wed, 17 Feb 2016 12:29:00 GMT

ok raj..

=count( DISTINCT if(Exec_PlanDate <= Now(),Exec_TestID))

in this exp am getting not exct values.

i am getting multiple date values.

as i need distinct latest date value to be taken