Solved: Set Analysis Operator: link 2 fields - Qlik Community

Anonymous · ‎2016-09-19

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

sunny_talwar · ‎2016-09-19

Or may be this:

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

swuehl · ‎2016-09-19

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

sunny_talwar · ‎2016-09-19

Or may be this:

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

Anonymous · ‎2016-09-22

I tried and it didn't work

Anonymous · ‎2016-09-22

This is perfect.

Thx