Using Where & AND Clauses in expression

[bashar_f]

I want to count the records where both these conditions are true

count({<Semester={"=Left(Semester, 2) = $(vPreviousYear)", "PROG_ACTION = {'ADMT','MATR'} "}>} EMPLID)

Is this not how you do an AND in qlikview?

[israrkhan · Accepted solution]

try this

=count({<Semester={"=Left(Semester, 2) = $(vPreviousYear)"}, PROG_ACTION = {'ADMT','MATR'} >} EMPLID)

or

=count({<Semester={"$(=Left(Semester, 2)) = $(vPreviousYear)"}, PROG_ACTION = {'ADMT','MATR'} >} EMPLID)

and comma , represent and in expression.

you had one extra " mark in the expression. and curly brackets was on wrong

[#3]

Hello,

I am trying to create a calculated parameter in Qlikview which needs to be calculated only when a certain condition is met. This expression needs to work on only those rows where actuals_sa in not blank. How do I add a where clause in this expression?

= num(

         max

              (Aggr

                     ( Sum ( actuals_sa ) , calender_date) /Aggr ( Sum ( CPE) , calender_date )

              ) , '#.##%'

          )

Thanks