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

Explain the expression

Please need help to understand the expression :

sum({< [Fiscal Month]=, [Sale Month]={"<=$(MaxPriorPeriod1)>=$(MaxPriorPeriod3)"} >} Qty)

1 Solution

Accepted Solutions
veidlburkhard
Creator III
Creator III

...the summation of Qty is done for the periods from MaxPriorPeriod1 to MaxPriorPeriod3 regardless of your selection of Fiscal Month.

Regards

Burkhard

View solution in original post

2 Replies
veidlburkhard
Creator III
Creator III

...the summation of Qty is done for the periods from MaxPriorPeriod1 to MaxPriorPeriod3 regardless of your selection of Fiscal Month.

Regards

Burkhard

robert_mika
Master III
Master III

Sum Quantity between  SalesMonth  greater than MaxPeriod1 but less that MaxPeriod3.

The Fiscal Month part is there to ignore your selection of this field

MaxPerdiod1 and MaxPeriod3 are variables