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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculation on above Dimensional Value

Hi - I have a straight table and like to check if the dimensional value matches the value above:  I've looked at the Above() function, but this seems to be for expressions and not dimensional values. 

Looking for something like this:

If (Person = Person on Previous Row, THEN Same, ELSE Different)

Eg:

RowPerson (Sorted Alphabetically)Dimensional Calculation
1David-
2JohnDifferent (to Row 1)
3JohnSame (as Row 2)
4JohnathanDifferent (to Row 3)
5SteveDifferent (to Row 4)
6SteveSame (as Row 5)

Help appreciated

Jay

Labels (1)
12 Replies
Not applicable
Author

Thanks - I'll check it out and validate if its working against my dataset.

Anil_Babu_Samineni

I am talking about Script

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Not applicable
Author

Thanks Anil / Tresesco  - two great ways to get to my desired solution