Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

wunderch
New Contributor III

Amount by Min Date and Country

Hi,

I have the following table:

CountryDateAmount
Germany25.10.2013100
Germany02.10.2013500
USA04.05.201350
USA10.05.201380
Greece08.03.201320
Greece10.03.201360

Now I only want the Amount from the first date by Month and Country, so that the result is:

CountryDateAmount
Germany02.10.2013500
USA04.05.201350
Greece08.03.201320

I can't do it in the script with "First" and "group by", because I need all rows of the table for other calculations.

Any ideas?

Thanks

Chris

1 Solution

Accepted Solutions
Employee
Employee

Re: Amount by Min Date and Country

Straight Table

One dimension: Country

Two Expressions:

1) Min(Date)

2) FirstSortedValue(Amount,-Date)

1 Reply
Employee
Employee

Re: Amount by Min Date and Country

Straight Table

One dimension: Country

Two Expressions:

1) Min(Date)

2) FirstSortedValue(Amount,-Date)

Community Browser