Group by

[#1]

Hi All,

Can any one help me with the below.

I have country and Date dimension and a fact.

I want to select country and respective max date.

e.g.: AUS May 01- 2014

        AUS  May 27 2014.

I want to display country and max(date) for that country in dashboard. I have used MAX(Date). But having multiple entries for the same country.

Can any one tell, how to retain one entry per country.

Thanks in advance.

[#2]

it depends on what she is trying to achieve. if she wants the expressions only for the max(date) calculated then she has to use it as a dimension. if she just wants to see the max date then she should use it as and expression

[hic]

No, the solution should not have date as dimension. One value per country was the requirement. That means Country as dimension and Max(Date) as expression. Nothing more is needed.

See more on http://community.qlik.com/blogs/qlikviewdesignblog/2013/03/25/dimensions-and-measures

HIC

[#4]

hey,

you could try aggr(max(date),country)

[hic]

Aggr() is in this case an unnecessary complication that takes longer to evaluate. Why use it when you don't need it? Further, if you want it as expression, you need to wrap it in an aggregation function to make it work.

I suggest your read

http://community.qlik.com/blogs/qlikviewdesignblog/2013/03/11/when-should-the-aggr-function-not-be-u...

http://community.qlik.com/blogs/qlikviewdesignblog/2014/05/19/function-classes

HIC

[saikatghosh]

Hi Avinash,

if you want to group by on script level then your script should  be like this. and in table view select MAXDATE along with Country.

Table1:

Load
COUNTRY,
Date(MAX(DATE),'DD-MM-YYYY') as MAXDATE
Resident  MainTable; //Earlier Table Name
Group by COUNTRY;

[davidg_curs]

Odsoten sem do 23.05.2014.

Odsoten sem 22.5.2014. Vaše sporočilo bom prebral in nanj po potrebi

odgovoril, ko se vrnem, to je 23.05.2014.

V nujnem primeru v zvezi z QLIKVIEW aplikacijami pa se obrnite na

g.Tekavčič Staneta oz. g.Oven Alojza.

Lep pozdrav

David

Opomba: To je samodejni odgovor na vaše sporočilo "Re: -

Group by" poslano naprej 22.5.2014 13:35:58.

To je edino sporočilo, ki ga boste prejeli, ko je oseba odsotna.

[davidg_curs]

Odsoten sem do 23.05.2014.

Odsoten sem 22.5.2014. Vaše sporočilo bom prebral in nanj po potrebi

odgovoril, ko se vrnem, to je 23.05.2014.

V nujnem primeru v zvezi z QLIKVIEW aplikacijami pa se obrnite na

g.Tekavčič Staneta oz. g.Oven Alojza.

Lep pozdrav

David

Opomba: To je samodejni odgovor na vaše sporočilo "Re: -

Group by" poslano naprej 22.5.2014 14:24:53.

To je edino sporočilo, ki ga boste prejeli, ko je oseba odsotna.

[davidg_curs]

Odsoten sem do 23.05.2014.

Odsoten sem 22.5.2014. Vaše sporočilo bom prebral in nanj po potrebi

odgovoril, ko se vrnem, to je 23.05.2014.

V nujnem primeru v zvezi z QLIKVIEW aplikacijami pa se obrnite na

g.Tekavčič Staneta oz. g.Oven Alojza.

Lep pozdrav

David

Opomba: To je samodejni odgovor na vaše sporočilo "Re: -

Group by" poslano naprej 22.5.2014 13:31:51.

To je edino sporočilo, ki ga boste prejeli, ko je oseba odsotna.

[davidg_curs]

Odsoten sem do 23.05.2014.

Odsoten sem 22.5.2014. Vaše sporočilo bom prebral in nanj po potrebi

odgovoril, ko se vrnem, to je 23.05.2014.

V nujnem primeru v zvezi z QLIKVIEW aplikacijami pa se obrnite na

g.Tekavčič Staneta oz. g.Oven Alojza.

Lep pozdrav

David

Opomba: To je samodejni odgovor na vaše sporočilo "Re: -

Group by" poslano naprej 22.5.2014 13:39:50.

To je edino sporočilo, ki ga boste prejeli, ko je oseba odsotna.

[davidg_curs]

Odsoten sem do 23.05.2014.

Odsoten sem 22.5.2014. Vaše sporočilo bom prebral in nanj po potrebi

odgovoril, ko se vrnem, to je 23.05.2014.

V nujnem primeru v zvezi z QLIKVIEW aplikacijami pa se obrnite na

g.Tekavčič Staneta oz. g.Oven Alojza.

Lep pozdrav

David

Opomba: To je samodejni odgovor na vaše sporočilo "Re: -

Group by" poslano naprej 22.5.2014 13:31:57.

To je edino sporočilo, ki ga boste prejeli, ko je oseba odsotna.