Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
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

Or may be this:

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

View solution in original post

4 Replies
swuehl
MVP
MVP

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

sunny_talwar

Or may be this:

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

Anonymous
Not applicable
Author

I tried and it didn't work

Anonymous
Not applicable
Author

This is perfect.

Thx