Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Partner
Partner

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
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


View solution in original post

2 Replies
Specialist II
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


View solution in original post

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