topic Re: OR command in set analysis in QlikView

OR command in set analysis

Mon, 19 May 2014 11:38:22 GMT

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.

Anonymous — Mon, 19 May 2014 11:47:19 GMT

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

anbu1984 — Mon, 19 May 2014 12:47:30 GMT

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

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

maxgro — Mon, 19 May 2014 21:20:32 GMT

adapt to your requirement

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

good help here