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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Using Set Expression for Current month and last month data

I am trying to use a set expression to calculate a yield percentage for a KPI for current month and prior month values.

The expression I am trying to use for this is as follows

Sum({1<Line={Line1, Line2, Line3},Process Month={Month(Today())}>} Yield output)

I want the KPI to be fixed for a set number of lines for this month.

Thank you!

0 Replies