Qlik Community

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?

Thx in advance.

1 Solution

Accepted Solutions
saurabh5
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
saurabh5
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)

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