Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
samvile18
Creator III
Creator III

Set Analysis Syntax

Morning all,

Can someone help me with the following syntax please;

=sum({<[Date Received]={'$(=Date([Upload Date]))'}, [Sales Channel]={'FriendsLife'},[Conversion Status]={'2 Tender Doc Issued'}, Status={'Won','Live'}>}APE)

This works fine at the moment as the two date fields are normal date fields so DD/MM/YYYY, I need to change the two date fields to fields to MonthName fields so they now look like this MMM-YYYY e.g. Jan-2012

As soon as I change the field names in the above syntax the results stop working and I keep getting zero's...I can;t figure out for the life of me what the problem is.

The new fields are called Date Received Month/Year and Upload Month/Year

Can anyone help?

1 Solution

Accepted Solutions
samvile18
Creator III
Creator III
Author

This has been answered in a separate post

View solution in original post

1 Reply
samvile18
Creator III
Creator III
Author

This has been answered in a separate post