topic Using Where & AND Clauses in expression in QlikView

Using Where & AND Clauses in expression

bashar_f — Sun, 20 Jul 2014 06:53:57 GMT

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?

Re: Using Where & AND Clauses in expression

israrkhan — Sun, 20 Jul 2014 07:03:54 GMT

try this

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

=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

Re: Using Where & AND Clauses in expression

Tue, 16 Aug 2016 20:58:53 GMT

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