Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
wuming79
Contributor

How to do proper Groupby in Qlik Sense Table?

Hi,

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

NameFruitDate
MikeApple20180101
MikeApple20180103
JohnBanana20180201
JohnBanana20180209

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


Name

FruitEarliest Date
MikeApple20180101
JohnBanana20180201
Tags (1)
1 Solution

Accepted Solutions
Partner
Partner

Re: How to do proper Groupby in Qlik Sense Table?

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; 

View solution in original post

9 Replies
Partner
Partner

Re: How to do proper Groupby in Qlik Sense Table?

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; 

View solution in original post

wuming79
Contributor

Re: How to do proper Groupby in Qlik Sense Table?

Can I do this after I loaded the data?

Luminary
Luminary

Re: How to do proper Groupby in Qlik Sense Table?

The front end alternative is AGGR().

AGGR(MIN(Date), Name, Fruit)

tomasz_tru
Valued Contributor

Re: How to do proper Groupby in Qlik Sense Table?

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

Tomasz

Partner
Partner

Re: How to do proper Groupby in Qlik Sense Table?

You can do it in edit script or in chart

wuming79
Contributor

Re: How to do proper Groupby in Qlik Sense Table?

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.

Partner
Partner

Re: How to do proper Groupby in Qlik Sense Table?

Use this

wuming79
Contributor

Re: How to do proper Groupby in Qlik Sense Table?

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

Partner
Partner

Re: How to do proper Groupby in Qlik Sense Table?

do you have access to qmc? import the app