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

How to do proper Groupby in Qlik Sense Table?

wuming79 — Thu, 18 Oct 2018 01:36:26 GMT

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

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

weijietc — Thu, 18 Oct 2018 02:28:03 GMT

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;

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

wuming79 — Thu, 18 Oct 2018 07:00:05 GMT

Can I do this after I loaded the data?

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

Ivan_Bozov — Thu, 18 Oct 2018 07:14:16 GMT

The front end alternative is AGGR().

AGGR(MIN(Date), Name, Fruit)

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

tomasz_tru — Thu, 18 Oct 2018 07:16:12 GMT

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

Tomasz

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

weijietc — Thu, 18 Oct 2018 07:20:34 GMT

You can do it in edit script or in chart

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

wuming79 — Thu, 18 Oct 2018 07:28:02 GMT

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.

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

weijietc — Thu, 18 Oct 2018 07:39:31 GMT

Use this

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

wuming79 — Thu, 18 Oct 2018 07:44:30 GMT

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

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

weijietc — Thu, 18 Oct 2018 07:47:58 GMT

do you have access to qmc? import the app