Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

anindya_manna
Contributor II

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
anindya_manna
Contributor II

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

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])

2 Replies
agigliotti
Honored Contributor II

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

let's try the below expression:

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

anindya_manna
Contributor II

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

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])