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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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)