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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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

Labels (1)
2 Replies
sunny_talwar
MVP
MVP

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)