Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
zagzebski
Creator
Creator

using above function to look at previous dimension

I want to do something like

If(Above([Group Name])=[Group Name],1,0)

Basically just want an expression that looks at the row above to see if the dimension Group Name is equal to the Group Name on current row.

Steve

2 Replies
sunny_talwar

Do you have more than one dimensions? May be this:

If(Above(TOTAL [Group Name])=[Group Name],1,0)

Chanty4u
MVP
MVP

try

may be

If(Above(ALL  [Group Name])=[Group Name],1,0)