Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

How to filter 2 criteria in data field in expression?

Hi,

Its me again.. sorry i'm new to QV..

I'm trying to add a code in the expression to filter two criteria "New" and "Under Clarification"..

I have a Straight Table  and i want to get the data only the status (field) is "New" and "Under Clarification" without selecting it in the List Table

I added this to my expression {<status = {'New' & 'Under Clarification'}>} but it is not working properly

here's my code

=count( {<status = {'New' & 'Under Clarification'}>}  {$<[Request Received] = {">=$(=Date(Today()-5))"}>} DISTINCT [Request Received])

Attached is my sample report

Thanks

1 Solution

Accepted Solutions
MVP
MVP

Re: How to filter 2 criteria in data field in expression?

try like:

=count( {<status = {'New' , 'Under Clarification'} ,[Request Received] = {">=$(=Date(Today()-5))"}>} DISTINCT [Request Received])

Update: PFA

2 Replies
MVP
MVP

Re: How to filter 2 criteria in data field in expression?

try like:

=count( {<status = {'New' , 'Under Clarification'} ,[Request Received] = {">=$(=Date(Today()-5))"}>} DISTINCT [Request Received])

Update: PFA

Not applicable

Re: How to filter 2 criteria in data field in expression?

Perfect! Thanks

Community Browser