topic using above function to look at previous dimension in QlikView

using above function to look at previous dimension

zagzebski — Thu, 07 Jul 2016 19:29:41 GMT

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

sunny_talwar — Thu, 07 Jul 2016 19:33:19 GMT

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

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

Chanty4u — Fri, 08 Jul 2016 06:33:23 GMT

try

may be

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