Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

How to add Bookmark filter with other filter in set expression?

Hi all,

I am writing a set expression with bookmark filter and other filters. But it is not working fine.When I am apllying BM(Id-qjyVTq) separately it is working fine like below.

sum({qjyVTq}[Sales Amt])

And when applying other filter it is also working fine

sum({$<[Product Type] = {'MF'},[Process Date]={">=$(=QuarterStart(Max([Process Date]))) <=$(=Max([Process Date]))"}>}[Sales Amt])

Now I want to combine this two like below

sum({$<{qjyVTq},[Product Type] = {'MF'},[Process Date]={">=$(=QuarterStart(Max([Process Date]))) <=$(=Max([Process Date]))"}>}[Sales Amt])

But this not working.

Experts Please help me on this.

Tags (2)
1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: How to add Bookmark filter with other filter in set expression?

Try like:

For non-overlapped set:

sum({ qjyVTq <[Product Type] = {'MF'},[Process Date]={">=$(=QuarterStart(Max([Process Date]))) <=$(=Max([Process Date]))"}>}[Sales Amt])

For overlapped set using OR operator:

sum({ qjyVTq + <[Product Type] = {'MF'},[Process Date]={">=$(=QuarterStart(Max([Process Date]))) <=$(=Max([Process Date]))"}>}[Sales Amt])

View solution in original post

2 Replies
Highlighted
MVP
MVP

Re: How to add Bookmark filter with other filter in set expression?

Try like:

For non-overlapped set:

sum({ qjyVTq <[Product Type] = {'MF'},[Process Date]={">=$(=QuarterStart(Max([Process Date]))) <=$(=Max([Process Date]))"}>}[Sales Amt])

For overlapped set using OR operator:

sum({ qjyVTq + <[Product Type] = {'MF'},[Process Date]={">=$(=QuarterStart(Max([Process Date]))) <=$(=Max([Process Date]))"}>}[Sales Amt])

View solution in original post

Highlighted
Partner
Partner

Re: How to add Bookmark filter with other filter in set expression?

Thanks.