topic previous score in QlikView

previous score

kunkumnaveen — Wed, 10 Feb 2016 08:48:38 GMT

Hello All, I am looking for suggestion from you guys,let us suppose if my given data is like below

location date score

mumbai 06/13/2015 40

mumbai 09/20/2015 50

mumbai 12/05.2015 60

pune 05/14/2015 100

pune 07/22/2015 110

pune 11/28/2015 120

Now...the whats the requirement is :

location currentscore previousscore

mumbai 60 50

pune 120 110

i had achieved the current score requirement by using this: firstsortvalue(score,-date) which gives me max date score which is current score

so will u guys please let me known how to achieve previous score

thanks

naveen

Re: previous score

MK_QSL — Wed, 10 Feb 2016 09:03:22 GMT

Use 2nd expression as below to get the previous score..

FirstSortedValue(score,-date,2)

Re: previous score

jagan — Wed, 10 Feb 2016 09:21:40 GMT

HI,

You can specify the 3rd parameter for this

firstsortvalue(score,-date, 2) - This gives the previous score.

Regards,

Jagan.

Re: previous score

MK_QSL — Wed, 10 Feb 2016 09:34:21 GMT

You selected answer as helpful so I am assuming that you haven't got the right answer. Please let us know the same so that we can help you further.

Re: previous score

kunkumnaveen — Wed, 10 Feb 2016 09:40:33 GMT

Hello Manish, i do got the answer what i am looking for , to close the thread i selected helpful..so if it is not the right way to close the thread please let me known how to close the thread

thanks

naveen

Re: previous score

Mark_Little — Wed, 10 Feb 2016 10:04:44 GMT

Hi,

You could always get the previous in the script,

Something like,

Load

IF(Rowno() =1 or Location <> PEEK(Location,-1),

PEEK(Score,-1) ) AS PreviousScore

Resident 'Your table'

Order by Location, date;

Mark

Re: previous score

MK_QSL — Wed, 10 Feb 2016 11:30:01 GMT

Correct Answer is the one which can close the thread... Helpful means the thread is still open and you are looking for the correct answer.