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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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