Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

sum of least 13 value

hi all

     How could i find the sum of last 13 values

Tags (1)
1 Solution

Accepted Solutions
Highlighted

Re: sum of least 13 value

May be like this

Sum({<Value = {"=Rank(-Value) < 14"}>}Value)

View solution in original post

2 Replies
Highlighted

Re: sum of least 13 value

May be like this

Sum({<Value = {"=Rank(-Value) < 14"}>}Value)

View solution in original post

Highlighted
Creator
Creator

Re: sum of least 13 value

Thanks alot