# QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

## Formula with AND

Hello,

I have a formula

=Sum( {<BMIYEAR={\$(JaarVergelijking)}>} TOTAL )

and i want to have a clause added:

AND weeknumber <= Weeknumber of the sysdate.

How do i add this clause to my formula?

1 Solution

Accepted Solutions
Contributor II

## Re: Formula with AND

you can incorporate your other clause in the set analysis itself

something like:

=sum({<BMIYEAR={\$(JaarVergelijking},Weeknumber={"<=\$(=max(weekday(sysdate))"}>}Total)

2 Replies
Contributor II

## Re: Formula with AND

you can incorporate your other clause in the set analysis itself

something like:

=sum({<BMIYEAR={\$(JaarVergelijking},Weeknumber={"<=\$(=max(weekday(sysdate))"}>}Total)

MVP

## Re: Formula with AND

Write like

=Sum( {<BMIYEAR={\$(JaarVergelijking)}, weeknumber = {'<=\$(=Week(sysdate)  )'}     >} TOTAL  FieldName )

Otherwise

=Sum( {<BMIYEAR={\$(JaarVergelijking)}, weeknumber = {'<=\$(=Week(sysdate)  )'}     >} TOTAL  )

What is TOTAL here let me know

Regards

Anand