Announcements
cancel
Showing results for
Did you mean:
Partner - Creator

## Using Where & AND Clauses in expression

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?

1 Solution

Accepted Solutions
Specialist II

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

2 Replies
Specialist II

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

Not applicable

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

Community Browser