Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

marko_rakar
New Contributor III

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
Esteemed Contributor II

Re: Finding records which conform to multiple criteria

dimension

Document ID

Expression

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

Re: Finding records which conform to multiple criteria

May be a set analysis like this

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

Re: Finding records which conform to multiple criteria

My bad, should be this

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

Community Browser