topic Re: Set analysis for AND in QlikView

Set analysis for AND

Wed, 17 Oct 2012 17:52:10 GMT

count( if(not isnull(MinNoAfterFirstYes) and not isnull(MinFirstYes),if(Audit_Date>=Date_Master_From and Audit_Date<=Date_Master_To,CallID)))

How can i write it in set analysis method.....Please help....

Re: Set analysis for AND

CELAMBARASAN — Wed, 17 Oct 2012 18:17:39 GMT

You can achieve this using intersection operator.

Count({<MinNoAfterFirstYes={*}>}*{<MinFirstYes={*}>}*{<Audit_Date={">=$(=Date_Master_From)<=$(=Date_Master_To)"}>} CallID)

Re: Set analysis for AND

Wed, 17 Oct 2012 18:32:02 GMT

everything looking gud but its missing not null in above expression. How to use add that.

Re: Set analysis for AND

CELAMBARASAN — Wed, 17 Oct 2012 20:17:21 GMT

={*} is to return the non null values.

Re: Set analysis for AND

Thu, 18 Oct 2012 07:04:20 GMT

The expression provided by you is not working....Shows red lines in expression window of any chart object. Syntax error kind of thing.

Re: Set analysis for AND

teempi — Thu, 18 Oct 2012 08:54:43 GMT

Hello,

I don't think that {*} calculates null values because nulls cannot be selected. I would probably create a flag into the data that tells you if a certain field is null. Then you can use the flag to include those null rows.

-Teemu

Re: Set analysis for AND

Thu, 18 Oct 2012 12:53:21 GMT

Can you please provide me the syntax by assuming flag. Anyway I wil create flag. After that what will be the syntax for above expression which I have posted above....?

Please help.

Re: Set analysis for AND

Thu, 18 Oct 2012 12:53:38 GMT

Can you please provide me the syntax by assuming flag. Anyway I wil create flag. After that what will be the syntax for above expression which I have posted above....?

Please help.

Re: Set analysis for AND

CELAMBARASAN — Thu, 18 Oct 2012 15:07:28 GMT

What this means?

not isnull(MinNoAfterFirstYes)

Your trying to retrieve non null values. right?

It doesn't select null values it will select non null values..

Re: Set analysis for AND

Thu, 18 Oct 2012 17:54:03 GMT

I am talikng about this expression. It is not working. Shows syntax error when i put in expr

ession window. Can you provide me right syntax.

I tried by changing here and there but not worked. So please suggest.

Count({<MinNoAfterFirstYes={*}>}*{<MinFirstYes={*}>}*{<Audit_Date={">=$(=Date_Master_From)<=$(=Date_Master_To)"}>} CallID)

Re: Set analysis for AND

teempi — Fri, 19 Oct 2012 06:40:50 GMT

Hey,

Oops, my bad about the not isnull

Does this expression work?

Count({< MinNoAfterFirstYes={*}, MinFirstYes={*}, Audit_Date={">=$(=Date_Master_From)<=$(=Date_Master_To)"} >} CallID)

This should show you all the data that has non null values in fields "MinNoAfterFirstYes" and "MinFirstYes" and the date falls between the defined dates. If it gives you a syntax error, try replacing Audit_Date={">=$(=Date_Master_From)<=$(=Date_Master_To)"} with (for example) this to see if the date part is the problem:

Audit_Date={">=1.10.2012 <=31.10.2012"}

-Teemu

Re: Set analysis for AND

Fri, 19 Oct 2012 13:09:01 GMT

The expression provided by you is working fine but can you tell me why it shows red lines in expression window of any chart object. For set analysis only it shows like this. If I write the simple if condition then it wont show the red lines. Looks like syntax error but not exactly.(Means it works but red lines shows).

Re: Set analysis for AND

teempi — Fri, 19 Oct 2012 13:16:47 GMT

Hi,

Often when you use variables in set analysis, the parser thinks there's a syntax error even if there isn't. So basically it's just a "feature" of the parser component

-Teemu