topic OR in set analysis in QlikView

OR in set analysis

apthansh — Wed, 25 Nov 2020 16:16:04 GMT

How to put OR between 2 dates in the below set analysis ?

(Count({<

[Activity Status] ={'Active'},

[ Plan] = {"$(='>' & Date(Today()))"} or [Revised] = {"$(='>' & Date(Today()))"}

>} [ID]) )

If I do as below few ID's will get counted twice...

(Count({<

[Activity Status] ={'Active'},

[ Plan] = {"$(='>' & Date(Today()))"}

>} [ID]) )

(Count({<

[Activity Status] ={'Active'},

[Revised] = {"$(='>' & Date(Today()))"}

>} [ID]) )

Thanks Much

Re: OR in set analysis

sunny_talwar — Tue, 18 Oct 2016 20:01:22 GMT

May be like this:

Count({<[Activity Status] ={'Active'}, [ Plan] = {"$(='>' & Date(Today()))"}>+<[Activity Status] ={'Active'}, [Revised] = {"$(='>' & Date(Today()))"}>} [ID])

Read about the the set analysis operators here:

Implicit Set Operators

Re: OR in set analysis

sergio0592 — Tue, 18 Oct 2016 20:03:10 GMT

Try this (Sunny has helped me on a similar problem last week)

(Count({< [Activity Status] ={'Active'}, [ Plan] = {"$(='>' & Date(Today()))"}> + <[Activity Status] ={'Active'}, [Revised] = {"$(='>' & Date(Today()))"} >} distinct [ID]) )