How to do proper Groupby in Qlik Sense Table?

[wuming79]

Hi,

Is there a documentation on how to do the following groupby?

Name	Fruit	Date
Mike	Apple	20180101
Mike	Apple	20180103
John	Banana	20180201
John	Banana	20180209

I wanted to create another table that shows the earliest date Mike and John bought fruits.

Name	Fruit	Earliest Date
Mike	Apple	20180101
John	Banana	20180201

[weijietc · Accepted solution]

Table1:

LOAD * INLINE [

    Name, Fruit, Date

    Mike, Apple, 20180101

    Mike, Apple, 20180103

    John, Banana, 20180201

    John, Banana, 20180209

];

qualify *;

Table2:

Load Name,

Fruit,

Min(Date) as [Earliest Date]

resident Table1

Group by Name, Fruit; 

[wuming79]

Can I do this after I loaded the data?

[Ivan_Bozov]

The front end alternative is AGGR().

AGGR(MIN(Date), Name, Fruit)

[tomasz_tru]

Just use Min(Date) as a measure in the visualization

Tomasz

[weijietc]

You can do it in edit script or in chart

[wuming79]

sorry, how do I view this quick? I tried using Qlik Sense -> Data manager -> Data connections -> attachedFiles but Qlik Sense will have an error, "Unable to upload file "Fruits.qvw". This file type is not supported.

[weijietc]

Use this

[wuming79]

Hi, qvf is also not supported in Qlik Sense Enterprise.

[weijietc]

do you have access to qmc? import the app