topic Re: Set Analysis Conditions in QlikView

Set Analysis Conditions

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

Hello,

I've an expression and want to satisfy 8 conditions with one expression.

I used an expression provided by a member from here

=If(Count({<STATUS = {'C'}, STARTDT = {">=$(=Floor(SuccessDate))"}>}

STATUS) = 3,'Success',

If(Count({<STATUS = {'C'}>}STATUS) <>3,'Fail',Null()))

Conditions are:

If Startdate is less than Success Date and C count is 3 ----------- NULL

If Startdate is less than Success Date and C count is not equal to 3 ----------- Fail

If Startdate is equal to Success Date and C count is not equal to 3 ----------- Fail

If Startdate is equal to Success Date and C count is equal to 3 ----------- Success

If Startdate is greater than Success Date and C count is equal to 3 ----------- Success

If Startdate is greater than Success Date and C count is not equal to 3 ----------- Fail

If Startdate is greater than or equal to Success Date and C count is not equal to 3 ----------- Fail

But some how it is not satisfying all conditions.

Problem I'm facing is:

Success Date is based upon Extract of a file, hence I'm taking QVD refresh time to get the success date. In my QMC I've this extract file task way below and the above qvw file with conditions is on top.

So success date will not be refreshed unless the Extract qvd in refreshed.

The purpose of this set expression is to send emails to developers if the DB load was success/fail/no change.

stalwar1‌ jontydkpi‌ loveisfail‌

Thanks.

Re: Set Analysis Conditions

sunny_talwar — Thu, 08 Dec 2016 16:43:43 GMT

May be this:

=If(Count({<STATUS = {'C'}, STARTDT = {">=$(=Floor(SuccessDate))"}>}

STATUS) = 3,'Success',

If(Count({<STATUS = {'C'}, STARTDT = {">=$(=Floor(SuccessDate))"}>}STATUS) <>3,'Fail',Null()))

Re: Set Analysis Conditions

MK9885 — Thu, 08 Dec 2016 17:28:53 GMT

It's not satisfying many conditions.

I'm attaching the sample QVW.

You change the dates in Inline to verify the conditions.

Thanks.

Re: Set Analysis Conditions

sunny_talwar — Thu, 08 Dec 2016 17:33:51 GMT

Change the dates in Inline? Where exactly are you using that expression? Guide me man

Re: Set Analysis Conditions

MK9885 — Thu, 08 Dec 2016 17:36:01 GMT

I'm testing those dates in Text file.

And for changing dates and checking different condition, I suggested you can do it in Inline.