Count irrespective of selection

[#1]

Hi All,

I have an expression which returns list of users.

Below is the expression:

if(Opp_CreatedDate<>Null()

and len(trim(Enq_Followup_Date))=0

and len(trim(SitevisitDate))=0

and  len(trim(Off_Start_Date))=0

and len(trim(TermSheetSignedDateTime))=0

and (CurrentStatus<>'Dropped' or CurrentStatus<>'Expired')

,Enq_ContactName)

I want the count of the the users(Enq_ContactName) based on the above condition.

Regards,

Keerthi KS

[sunny_talwar]

So I am guessing that this is working without selection, you just want to make sure that it should not change based on any selection? If the above statement is true, than may be try this:

=Only Count({1} If(Only({1} Opp_CreatedDate) <> Null()

and Len(Trim(Only({1} Enq_Followup_Date))) = 0

and Len(Trim(Only({1} SitevisitDate))) = 0

and Len(Trim(Only({1} Off_Start_Date))) = 0

and Len(Trim(Only({1} TermSheetSignedDateTime))) = 0

and (Only({1} CurrentStatus) <> 'Dropped' or Only({1} CurrentStatus) <> 'Expired'), Enq_ContactName))

[miguelbraga]

Hi Keerthi,

You can do it by setting a variable in the variable overview and name it like this [vExpression]. Then you can use it by doing this:

=count( ($(vExpression)) )

I think this can really solve your problem. If not please tell me your output

Regards,

MB

[datanibbler]

Hi Keerthi,

I don't quite understand - to get answers to any kind of issue in QlikView fast, your post should have an "I have" and an "I want", you have those two all right - but there should be some kind of description of your issue in your post as well - what is it that you cannot do?

Counting with an IF_condition should not be hard - just wrap the COUNT() with the field that you want to cound around your IF_condition and that should be that.

Disregarding user_selections is not hard either - with an aggregation_function like COUNT(), just use a set_expression like COUNT({1} ... )

HTH

[sasikanth]

HI ,

Try this one,

=Count({<CurrentStatus={'*'}-{'Dropped','Expired'}>}

if (  not isNull(Opp_CreatedDate) and

             len(trim(Enq_Followup_Date))=0

               and len(trim(SitevisitDate))=0

               and  len(trim(Off_Start_Date))=0

               and len(trim(TermSheetSignedDateTime))=0,Enq_ContactName))