topic Re: How to Add Where Clause to a Variable Definitions in QlikView

How to Add Where Clause to a Variable Definitions

bashar_f — Thu, 17 Jul 2014 09:02:07 GMT

Hi,

I have a variable.called [vAdmissionsCount]

I'd like this variable to be defined as

count(emplid) Where prog_action = ADMT or MATR

prog_action being one of the fields, I get red lines all over, what am I doing wrong?

VishalWaghole — Thu, 17 Jul 2014 10:56:36 GMT

Hi Bashar,

Try this

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

-- Regards,

Vishal Waghole

er_mohit — Thu, 17 Jul 2014 11:00:54 GMT

Try this

count(distinct if(wildmatch(prog_action,'ADMT','MATR'),emplid))

here distinct keyword gives you the unique records means count single empid if it comes repetative