topic Re: Loading only the maximum value to every cell in a column in QlikView

Loading only the maximum value to every cell in a column

Mon, 22 Jun 2015 06:02:29 GMT

Dear community,

I have a case where I need to create a column the maximum value that is in another column.

The data looks like this:

The goal is to get a column with the max date in every cell:

I have a big data set and multiple sheets, so I need to make the operation nice and easy.

Thank you guys!

tresB — Mon, 22 Jun 2015 06:06:20 GMT

temp:

Load

max(Date) as MaxDate

From <>;

Let vMaxDate=Date(Peek('MaxDate'));

Drop table temp;

final:

Load

'$(vMaxDate)' as Date,

Data

From <>;

MayilVahanan — Mon, 22 Jun 2015 06:08:49 GMT

try some thing like this

Table1:

LOAD Date(Date#(Date,'DD.MM.YYYY')) as Date, Data INLINE [

Date, Data

01.01.2015, 100

01.01.2015, 200

,150

01.01.2016, 100

,120

01.01.2018, 130

,140

01.01.2015, 170

];

Join(Table1)

LOAD Date(max(Date)) as MaxDate Resident Table1;

Edit:

Use, MaxDate as Dimension.

Kushal_Chawda — Mon, 22 Jun 2015 06:26:32 GMT

Please see the attached one

Mon, 22 Jun 2015 09:10:41 GMT

Please find the attached QVW file.I have done it at script level.