topic Max Date rating logic in QlikView

Max Date rating logic

Anonymous — Thu, 29 Sep 2016 06:12:52 GMT

Hi All,

I have a table with following columns

confid ,

userid,

feedbakdate,

rating

What i wish to achieve is for a given conference should have only one rating per user .

In the current scenario one user can give multiple rating for a single conference.

I need to pick only the latest of all ratings given by the same user as per the latest date.

Please help me with the logic.

Thanks and Regards,

Nishant Nadkarni

sunny_talwar — Thu, 29 Sep 2016 16:02:10 GMT

May be like this:

Table:

LOAD confid ,

userid,

feedbakdate,

rating,

DateField

FROM Source....

Right Join (Table)

LOAD confid,

userid,

Max(DateField) as DateField

Resident Table

Group By confid, userid;

Anonymous — Thu, 29 Sep 2016 16:06:27 GMT

try this in a pivot table or straight table

Aggr(max(feedbakdate),confid,userid)

Anonymous — Fri, 30 Sep 2016 05:58:29 GMT

Hi Sunny,

Thanks a lot .It worked

Thanks and Regards,

Nishant Nadkarni