topic Re: Finding records which conform to multiple criteria in QlikView

Finding records which conform to multiple criteria

marko_rakar — Tue, 08 Aug 2017 12:10:18 GMT

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)

Re: Finding records which conform to multiple criteria

vinieme12 — Tue, 08 Aug 2017 12:13:44 GMT

dimension

Document ID

Expression

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

Re: Finding records which conform to multiple criteria

sunny_talwar — Tue, 08 Aug 2017 12:19:25 GMT

May be a set analysis like this

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

Re: Finding records which conform to multiple criteria

sunny_talwar — Tue, 08 Aug 2017 12:21:27 GMT

My bad, should be this

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