topic Re: where to put parenthesis in QlikView

where to put parenthesis

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

Can anyone help me with where to put the parenthesis in this expression. Can't for the life of me figure out where I'm going wrong.

=SUM(IF(Year(DocumentDate) = YEAR(Today())-1 and month(DocumentDate) < month(Today()) or Year(DocumentDate) = YEAR(Today())-1 and (month(DocumentDate) = month(Today())

and (day(DocumentDate) =< day(Today()),1,0))

Re: where to put parenthesis

ychaitanya — Mon, 19 Mar 2018 19:35:37 GMT

try This

=SUM(

IF(

(Year(DocumentDate) = YEAR(Today())-1 and month(DocumentDate) < month(Today()) )

(Year(DocumentDate) = YEAR(Today())-1 and month(DocumentDate) = month(Today()) )

and

day(DocumentDate) <= day(Today())

,1,0)

)

Re: where to put parenthesis

shiveshsingh — Tue, 20 Mar 2018 06:01:08 GMT

Can you tell on what condition you need 1 and on what 0?

Re: where to put parenthesis

chinnuchinni — Tue, 20 Mar 2018 06:16:10 GMT

try with this.....

=sum(

if (

year(DocumentDate)=year(today())-1 and month(Documentdate) < month(today()) or

(year(DocumentDate) =year(today()) -1 and month(DocumentDate) = Mlonth(today()) and day(documentDate) <= day(today())),

1, 0

)

Re: where to put parenthesis

pradosh_thakur — Tue, 20 Mar 2018 07:00:04 GMT

Is this what you want ? looks much simpler with this

=SUM(IF(Year(DocumentDate) = YEAR(Today())-1 and month(DocumentDate) <= month(Today())

and day(DocumentDate) =< day(Today()),1,0))

Re: where to put parenthesis

Anonymous — Tue, 20 Mar 2018 12:43:31 GMT

Hi Robert,

Placing parenthesis will depends up on expected output.

Can you explain briefly, while using this condition what is the expected output ?

Kindly post a sample workbook. It will helps to all to understand your requirement clearly.

Thanks,

Venkata Sreekanth