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: 
Not applicable

Using Cycle Group as <Group> in sum(Total <Group> Field) function

sum( {1< Manufacturer = >}Total <[Calendar Year]> [Total Sales])

How do I get the above formula to change based on the field in the Cycle Group?  The below wont work.

sum( {1< Manufacturer = >}Total <GetCurrentField(InvCycDate)> [Total Sales])

1 Reply
Not applicable
Author

try [cyclegroup] as:

sum( {1< Manufacturer = >}Total <[GetCurrentField(InvCycDate)]> [Total Sales])