Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

OR command in set analysis

Hello,

The following expression is working

COUNT({< ServiceDescription = {"Residential"},[CareEpisode
admissionDate]
= {"<=$(=Date(vDate25thNov))"},

[CareEpisode
leaveDate]
= {">=$(=Date(vDate25thNov))"} >}distinct [Client Res ID])

but I would like to add

an OR command

so leavedate => 25th Nov OR leavedate  is equal to '01/01/1900'

I know that the '+' sign is apparently used for OR in set analysis but I cannot get this to calculate at all.

Any ideas please?

Thanks.

3 Replies
Highlighted
Specialist II
Specialist II

Re: OR command in set analysis

COUNT({< ServiceDescription = {"Residential"},[CareEpisode
admissionDate]
= {"<=$(=Date(vDate25thNov))"},

[CareEpisode
leaveDate]
= {">=$(=Date(vDate25thNov)) =$(=makedate(1900,1,1))"} >}distinct [Client Res ID])




Use now, Hope it will help you out

Highlighted
Master III
Master III

Re: Re: OR command in set analysis

COUNT({< ServiceDescription = {"Residential"},[CareEpisode
admissionDate]
= {"<=$(=Date(vDate25thNov))"},

[CareEpisode
leaveDate]
= {">=$(=Date(vDate25thNov)) <=$(=makedate(1900,1,1))"} >}distinct [Client Res ID])

Highlighted
MVP
MVP

Re: OR command in set analysis

adapt to your requirement

=Sum( {$<d={"$(=max(d))"}+{"$(=min(d))"}>} Expression1)

good help here

Set Analysis: syntaxes, examples