Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Partner
Partner

How to add a where clause to a variable definition

Hi,

I have a variable called vAdmissionsCount

The definition is supposed to be

count(emplid)  Where prog_action = ADMT or MATR

prog_action is a field, but when i enter the definition like this, I get red lines all over.

1 Solution

Accepted Solutions
MVP
MVP

=Count( {<prog_action={'ADMT','MATR'}>}emplid)

View solution in original post

2 Replies
MVP
MVP

=Count( {<prog_action={'ADMT','MATR'}>}emplid)

View solution in original post

Partner
Partner

Try this

=Count( {<$(vAdmissionsCount)>}emplid)


you have to create de var with this value


prog_action={'ADMT','MATR'}