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

Announcements
Share your agentic AI experience, learn from others, and earn a new badge: Put Agentic AI to Work
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

To sum Previous data values using built in functions

hi,

I am getting the previous month value using variable PeriodN....with below formula

=FIELDVALUE('PeriodName', FIELDINDEX('PeriodName', ONLY(PeriodName))-1)

And in expression

Sum ({$<PeriodName={'$(#PeriodN)'}>}Values)

Is any other possibility to bring the values using the functions fieldvalue,fieldindex in an expression statement itself to find the same sum of values.

without using variable and assigning it,,,

Labels (1)
0 Replies