Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
marko_rakar
Creator
Creator

Finding records which conform to multiple criteria

If I have a database with following records:

Document ID, Value

1,A

1,C

2,B

2,C

3,A

3,B

3,C

4,A

4,D

4,E

I have thousands of records of this type, I would like to make selection (and make table or table chart) representation of all documents which include any of the values I select. For example, I would like to make selection of documents which includes values A and values C or D?

So in the case above, in my table I would get all rows from documents 1, 3 and 4.

How would I approach making query or selection like this? (if possible, I am looking at this and my mind draws blank)

3 Replies
vinieme12
Champion II
Champion II

dimension

Document ID

Expression

Count({<Value={'A','C','D'}>}Distinct [Document ID])

sunny_talwar

May be a set analysis like this

{<[Document ID] = P({<Value = {A}>})+P({<Value = {C, D}>})>}

sunny_talwar

My bad, should be this

{<[Document ID] = P({<Value = {A}>})*P({<Value = {C, D}>})>}