Group by for a Straight Table Chart

[#1]

Hi All,

Can anyone help me with this issue I need to resolve using a group on straight table chart.

I have a max(date) expression and a user id as a dimension.

I only want to display the last date in the chart.

e.g.
ID USERID Date
1 User1 16/06/09
1 User2 19/06/07

I would only like to display
ID USERID Date
1 User1 16/06/09

The version of Qlikview I am using is 8.5
Thanks a lot,

Kevin.

[Anonymous · Accepted solution]

My advice is to pre-calculate max date per USERID (or per ID? - can't tell for sure what you need).
LOAD
USERID,
max(Date) as MaxDate // use it in table
RESIDENT...
GROUP BY USERID;

[Oleg_Troyansky]

If I understand you correctly, you want to see the user that pertains to the latest dat by ID?

1. Your dimension should be ID (not the user).

2. You will have two expressions:

- max(Date)

- FirstSotredValue(USERID, Date*-1)

cheers,

Oleg