topic Re: tying to get max date using first sort value in QlikView

tying to get max date using first sort value

kunkumnaveen — Thu, 03 Mar 2016 07:44:04 GMT

Hello All,

my expression was working fine till yesterday ,but not now .....

i am trying to get max(date_of_ review) =TOTAL_SCORE value....for each individual to achieve that i wrote

in a stright table:

dimension:name1

expression:FirstSortedValue({<ROLE={'SELF_EVAL'}, ENSTEHDAT = >}TOTAL_SCORE, -DATE_OF_REVIEW)

in my date AMIT INDUSTRYS Score occurs three time ...i want to show only this latest DATE_OF_REVIEW AND

second latest DATE_OF_REVIEW

in two diff columns in a stright table ...

but by writing above expression i am getting all .....insteady of those two

please find the attachment

naveen

Re: tying to get max date using first sort value

Digvijay_Singh — Thu, 03 Mar 2016 08:13:53 GMT

May be you can use sort weight as last parameter in firstsortedvalue as 1 and 2.

Re: tying to get max date using first sort value

kunkumnaveen — Thu, 03 Mar 2016 08:23:09 GMT

Hello,

can u please able to give more brief explanation on that

thanks

naveen

Re: tying to get max date using first sort value

kunkumnaveen — Thu, 03 Mar 2016 08:29:16 GMT

sunindia‌gwassenaar‌

Hello guys ....can any one of you help me in achieving this requirement

thanks

naveen

Re: tying to get max date using first sort value

Digvijay_Singh — Thu, 03 Mar 2016 08:40:43 GMT

As I understand, you want to show TOTAL_SCORE against your specified dimension but you have multiple record for the dimension with different DATE_OF_REVIEW and you want to see latest and second latest DATE_OF_REVIEW.

Like this may be -

example script -

Load * inline [

Name, Score, Date

AmitInd,99,03-03-2016

AmitInd,98,02-03-2016

AmitInd,97,01-03-2016 ];

Re: tying to get max date using first sort value

MK_QSL — Thu, 03 Mar 2016 09:05:10 GMT

FirstSortedValue({<ROLE={'SELF_EVAL'}, ENSTEHDAT = >}TOTAL_SCORE, -DATE_OF_REVIEW)

FirstSortedValue({<ROLE={'SELF_EVAL'}, ENSTEHDAT = >}TOTAL_SCORE, -DATE_OF_REVIEW, 2)