Qlik Community

Ask a Question

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Max value for current and prev periods

I have 2 fields the first 1 in by Daily page views and the second in weekly.

I need to create a field that will hold the max value of page views for the specific Week and the previous weeks,

ATTACHED AN EXAMPLE.

(The right field is what I expect to get- Preferred to be made in layout)

Thanks

3 Replies

May be this

RangeMax(Above(YourExpression), 0, RowNo()))

Contributor III
Contributor III

WOW!!!!!!

Thanks Alot   !!!!!!!!!!!!!!!

Contributor III
Contributor III

Thanks it's correct!!!