topic Re: first value in QlikView

first value

raadwiptec — Wed, 25 Nov 2020 16:16:04 GMT

My scenario as below

My output is in a table box

I receive 2 Values kind of duplicate

for ex

Customer no | Date | Reciept No | Amount | product Number

100235 | 10/Mar/2010 | 22565 | 2.225 | EF2887817

100235 | 20/Mar/2010 | 22565 | 2.225 | EF2887817

The Data comes from current file and history file. I would like to display as one record as this is actually a duplicate but showing 2 different values because of the difference in dare.

Re: first value

Chanty4u — Mon, 14 Mar 2016 09:58:34 GMT

if u want to use one field value

u can use max(urdate field) it will give u the updated values

Re: first value

avinashelite — Mon, 14 Mar 2016 10:03:16 GMT

you could add a expression to fetch the max date add show the same

max(Date)

aggr( max(Date), [Customer no] , [Reciept No] , Amount ,[product Number])

You cannot use expression in the table box ..so you need to reduce the data in the script level

Source:

LOAD *

from

table;

Noconcatenate

result:

LOAD [Customer no],

max( Date),

[Reciept No],

[Amount] ,

[product Number]

resident

source

group by

[Customer no],

[Reciept No],

[Amount] ,

[product Number];

drop table Source;