Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to write set expression?

  how to write set expression for below code

count ({<BusinessProcessStatus={'New'} DepartmentGUID)

7 Replies
newqlikie
Creator
Creator

Hi,

try this:

count ({$<BusinessProcessStatus={'New'}>} DepartmentGUID)

Regards

nizamsha
Specialist II
Specialist II

=count({$<BusinessprocessStatus={"New"}>}departmentguid)

Not applicable
Author

Hi thanks

its working fine

but i want distinct department guid.

thanks

newqlikie
Creator
Creator

=count({$<BusinessprocessStatus={"New"}>}distinct(departmentguid))

Not applicable
Author

count(DISTINCT{$<BusinessprocessStatus={"New"}>}departmentguid)

nizamsha
Specialist II
Specialist II

count(DISTINCT{$<BusinessprocessStatus={"New"}>}departmentguid

Not applicable
Author

try this

=count(Distinct  {$<BusinessprocessStatus={"New"}>}departmentguid)