Solved: Re: Set analysis for AND - Qlik Community

Report Inappropriate Content · ‎2012-10-17

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

teempi · ‎2012-10-19

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

View solution in original post

CELAMBARASAN · ‎2012-10-17

You can achieve this using intersection operator.

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

Report Inappropriate Content · ‎2012-10-17

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

CELAMBARASAN · ‎2012-10-17

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

Report Inappropriate Content · ‎2012-10-18

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

teempi · ‎2012-10-18

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

Report Inappropriate Content · ‎2012-10-18

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.

Report Inappropriate Content · ‎2012-10-18

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.

CELAMBARASAN · ‎2012-10-18

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

Report Inappropriate Content · ‎2012-10-18

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)