continues in set analysis

[soniasweety]

Hi All,

@tresesco @MayilVahanan  @Taoufiq_Zarra 

i wan to count the user id where   L1  exams continues 3times failed only ..

 here is my expression 

count({<level={1}},avgscore ={"<60"}>}User_id)      here failed criteria is  ( <60% is failed )    I have field  Avg_score.

I wan to include  3times continues failed Leval1 failed candidates only.

[soniasweety]

Thanks . but without modifying script cant we do in front end only?

[tresesco · Accepted solution]

@soniasweety , @Taoufiq_Zarra Try:

=count({<Level={'1'},user={"=count({<Avgscore={[<60]}>}Level)>2"}>} distinct user)

Note: quotation has got modified meaning in latest versions of qv. And with this expression both of you would see the same result, unlike in the other case (expression with single quotes). 🙂

[soniasweety]

Good to know 🙂 thanks its working fine now.

[soniasweety]

Hi @tresesco   @MayilVahanan 

one small issue im facing  .. I want to exclude null values in this set expression.. how can I exclude nulls?

=count({<Level={'1'},user={"=count({<Avgscore={[<60]}>}Level)>2"}>} distinct user)

[MayilVahanan]

Hi @soniasweety 

Exclude nulls based on which field? , please find the common syntax to exclude nulls in set analysis

{<YourFieldName= {"=Len(Trim(YourFieldName)) > 0"}

or

{<YourFieldName= {"*"}>}

[soniasweety]

Hi ,

Thank you. I tried this working fine.

Field-={""}