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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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)