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: 
samvile18
Creator III
Creator III

Syntax help please...

Hi all,

I'm trying to add two different set analysis strings to the results of an IF statement, this is what I need to do:

I need to sum everything when ExtractDate equals my vJanEnd...can someone help me with the set analysis syntax please?

1 Solution

Accepted Solutions
giakoum
Partner - Master II
Partner - Master II

Assuming that vJanEnd is a variable :

sum({$<ExtractDate]={"$(vJanEnd)"}>} [YourField])

View solution in original post

3 Replies
giakoum
Partner - Master II
Partner - Master II

Assuming that vJanEnd is a variable :

sum({$<ExtractDate]={"$(vJanEnd)"}>} [YourField])

samvile18
Creator III
Creator III
Author

You're a HERO

giakoum
Partner - Master II
Partner - Master II

I seriously doubt that...