Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
ehe
Not applicable

Set Analysis Operator: link 2 fields

Is it possible to use the following in a set analyse ?

Aim is to neglect the value(s) selected for the [Schedule quater], but instead use the value(s) for the field [close quarter]

Sum( {$< [Schedule Quarter]=, [Close Quarter]=[Schedule Quarter] >} [Sales])

1 Solution

Accepted Solutions
sunny_talwar
Not applicable

Re: Set Analysis Operator: link 2 fields

Or may be this:

Sum({$<[Schedule Quarter]=, [Close Quarter] = p([Schedule Quarter])>} [Sales])

4 Replies
swuehl
Not applicable

Re: Set Analysis Operator: link 2 fields

This could work, at least the syntax is ok, have you tried it?

sunny_talwar
Not applicable

Re: Set Analysis Operator: link 2 fields

Or may be this:

Sum({$<[Schedule Quarter]=, [Close Quarter] = p([Schedule Quarter])>} [Sales])

ehe
Not applicable

Re: Set Analysis Operator: link 2 fields

I tried and it didn't work

ehe
Not applicable

Re: Set Analysis Operator: link 2 fields

This is perfect.

Thx