# New to QlikView

Discussion board where members can get started with QlikView.

Contributor III

## Set Analysis: Sum Bookmark Value with two between days

Hi Friends,

How to sum bookmark value and two between days using set analysis.

1. Ex: SUM({BM02 <SALESDATE={">=\$(WEEKSTART(DATE))<=\$(WEEKEND(DATE))"}>} SALESQTY)

As Same None Bookmark using is work

2. Ex: SUM({<SALESDATE={">=\$(WEEKSTART(DATE))<=\$(WEEKEND(DATE))"}>} SALESQTY)

With Regards,

V.Muni

1 Solution

Accepted Solutions
Valued Contributor II

## Re: Set Analysis: Sum Bookmark Value with two between days

Hi muni,

Muni Ur Expression is Wrong Please check thiis Expression

=SUM({BM02 <SaleDate={">=\$(=weekstart(Date(DATE)))<=\$(=weekend(Date(DATE))"}>} SalesAmount)

3 Replies
Valued Contributor II

## Re: Set Analysis: Sum Bookmark Value with two between days

Hi muni,

Muni Ur Expression is Wrong Please check thiis Expression

=SUM({BM02 <SaleDate={">=\$(=weekstart(Date(DATE)))<=\$(=weekend(Date(DATE))"}>} SalesAmount)

Contributor III

## Re: Set Analysis: Sum Bookmark Value with two between days

Thankx Perumal A.

You expression is correct.

We are using variable must use = ?

Valued Contributor II

## Re: Set Analysis: Sum Bookmark Value with two between days

Hi,

when use function inside variable  u want to use '='  must.