Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
muniyandi
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
perumal_41
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
perumal_41
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)

muniyandi
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 = ?

perumal_41
Valued Contributor II

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

Hi,

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

Community Browser