topic Re: Formula with AND in QlikView

Formula with AND

Mon, 26 Jan 2026 18:19:17 GMT

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.

saurabh5 — Wed, 10 Dec 2014 20:09:18 GMT

you can incorporate your other clause in the set analysis itself

something like:

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

its_anandrjs — Wed, 10 Dec 2014 20:10:43 GMT

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