topic Group by for a Straight Table Chart in QlikView

Group by for a Straight Table Chart

Wed, 24 Jun 2009 23:20:35 GMT

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.

Group by for a Straight Table Chart

Anonymous — Wed, 24 Jun 2009 23:36:13 GMT

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;

Group by for a Straight Table Chart

Oleg_Troyansky — Wed, 24 Jun 2009 23:38:41 GMT

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