Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

RangeSum Table value as KPI

Hi all,

I have a table which shows the sum of the last 7 rows (see attached) . 

The table expression I'm using is:

RangeSum(Above( (Count( distinct ItemID)) , 0, 7))


I want to have the sum of the last 7 rows as a KPI chart but I'm finding it difficult to achieve this. 

Has anyone had this issue before and know how to make it work?

Many thanks all

Labels (1)
0 Replies