topic Re: Calculation on above Dimensional Value in QlikView

Calculation on above Dimensional Value

Fri, 19 May 2017 09:28:50 GMT

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:

Row	Person (Sorted Alphabetically)	Dimensional Calculation
1	David	-
2	John	Different (to Row 1)
3	John	Same (as Row 2)
4	Johnathan	Different (to Row 3)
5	Steve	Different (to Row 4)
6	Steve	Same (as Row 5)

Help appreciated

Jay

Re: Calculation on above Dimensional Value

Anil_Babu_Samineni — Fri, 19 May 2017 10:06:45 GMT

As i understand, Use this? And, I always recommend you to create in script

LOAD Row,

[Person (Sorted Alphabetically)],

If(Row, Previous(Row)) as [Dimension Calculation]

FROM

[https://community.qlik.com/message/1271470]

(html, codepage is 1252, embedded labels, table is @1);

Re: Calculation on above Dimensional Value

Fri, 19 May 2017 10:15:37 GMT

Hi Anil - that's not quite what I'm expecting...I added the Row column to help with the understanding of the problem.

Problem:

For the current row, I want to check the dimensional value of the previous row to determine if the same value.

Jay

Re: Calculation on above Dimensional Value

Anil_Babu_Samineni — Fri, 19 May 2017 10:17:42 GMT

May be not understand fully? Would you tell us expected result, That may helps

Re: Calculation on above Dimensional Value

Fri, 19 May 2017 10:26:21 GMT

hi - For simplicity, My qlikview straight table looks like this: (The duplicates are expected and needed).

Email
Person1@email.com
Person2@email.com
Person2@email.com
Person2@email.com
Person3@email.com
Person3@email.com
Person4@email.com

I want this output:

Email	Check
Person1@email.com
Person2@email.com	Different
Person2@email.com	Same
Person2@email.com	Same
Person3@email.com	Different
Person3@email.com	Same
Person4@email.com	Different

Thanks, Jay

Re: Calculation on above Dimensional Value

tresB — Fri, 19 May 2017 10:52:17 GMT

Like this?

Re: Calculation on above Dimensional Value

Fri, 19 May 2017 11:02:28 GMT

Tresesco B - Any chance you can put the code into a text file? I'm running a personal edition today and unable to open the file

Thanks Jay

Re: Calculation on above Dimensional Value

Anil_Babu_Samineni — Fri, 19 May 2017 11:04:55 GMT

If you are expecting same as Tresco suggestion, This may be

If(Email = Previous(Email),'Same','Different')

Re: Calculation on above Dimensional Value

tresB — Fri, 19 May 2017 11:06:53 GMT

Screen shots above?

Load *, RowNo() as Row Inline [

Email

Person1@email.com

Person2@email.com

Person2@email.com

Person2@email.com

Person3@email.com

Person3@email.com

Person4@email.com

]

Straight table:

Calculated dimension: =Dual(Email, Row)

Expression: =If( Email=Above(Email), 'Same', 'Different')

Re: Calculation on above Dimensional Value

Fri, 19 May 2017 11:07:52 GMT

'Previous' is not a valid function

Re: Calculation on above Dimensional Value

Fri, 19 May 2017 11:09:42 GMT

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

Re: Calculation on above Dimensional Value

Anil_Babu_Samineni — Fri, 19 May 2017 11:13:17 GMT

I am talking about Script

Re: Calculation on above Dimensional Value

Fri, 19 May 2017 14:33:18 GMT

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