Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vkish16161
Contributor III

Set Analysis - Advanced Search

All,

I have a scenario like this:

I want the sales of reps where reps have No. of Engagements between 1 and 2.

For this I want to write something like this..

Sum({<Reps = {"Count(Engagements)>1 and Count(Engagements)<2"}>}Sales)

Is this syntax correct?

stalwar1

Thanks!

Tags (1)
1 Solution

Accepted Solutions

Re: Set Analysis - Advanced Search

Yes it will because it is a search string

3 Replies

Re: Set Analysis - Advanced Search

Missing an equal sign

Sum({<Reps = {"=Count(Engagements)>1 and Count(Engagements)<2"}>}Sales)

vkish16161
Contributor III

Re: Set Analysis - Advanced Search

Yeah..

Thanks Sunny for pointing it out. I forgot.

But will set analysis accept the and operator?


stalwar1

Re: Set Analysis - Advanced Search

Yes it will because it is a search string

Community Browser