topic Re: Again - a simple exclusion required in QlikView

Again - a simple exclusion required

Tue, 13 Oct 2015 05:53:01 GMT

I seem to be running into simple problems - that for me seem difficult to resolve

Here I am reading a list of Released Batches from a transaction table

The Batch may be released all in one go on the one day - or partially over several days - or partially during the same day

All I need to report is the First Date is was released

The input file looks something like

Batch# Release-Date Release-Qty

A1 01/10/2015 100

A1 01/10/2015 200

A2 02/10/2015 50

A2 03/10/2015 60

A5 06/10/2015 300

All I am after are the first release details as part of a chart

Batch# First-Release

A1 01/10/2015

A2 02/10/2015

A5 06/10/2015

How is this best accomplished?

Re: Again - a simple exclusion required

Tue, 13 Oct 2015 05:57:24 GMT

See attached, used Min (Date([Release-Date]))

Re: Again - a simple exclusion required

Kushal_Chawda — Tue, 13 Oct 2015 06:01:02 GMT

Create straight table

Dimensions:

Batch#

Expression:

=aggr(date(min([First-Release]),'DD/MM/YYYY'),Batch#)

Re: Again - a simple exclusion required

tresB — Tue, 13 Oct 2015 06:04:53 GMT

With Batch# in dimension, aggr() would be redundant and should be avoided.

Simple: =Date(Min ([Release-Date]))

should be enough.

Re: Again - a simple exclusion required

tamilarasu — Tue, 13 Oct 2015 06:10:34 GMT

Hi David,

Is there any chance that the release quantity is high (100 - 1st release and 50 -2nd release) at first release.? If not, you can try the above solutions.

Re: Again - a simple exclusion required

NareshGuntur — Tue, 13 Oct 2015 06:11:34 GMT

This should simply do the trick while loading.

"not exists" will load only the values which are not already loaded.

Also have the qvw attached.

load * inline [

Batch#, Release-Date, Release-Qty

A1, 01/10/2015, 100

A1, 01/10/2015, 200

A2, 02/10/2015, 50

A2, 03/10/2015, 60

A5, 06/10/2015, 300

]

Where not Exists(Batch#);