topic Re: Selecting current value in QlikView

Selecting current value

Wed, 25 Nov 2020 16:16:04 GMT

I have case in which i want to select latest one entry

my data is as below

Project_Name Start_Date End_Date

ABC 12-12-15 12-12-16

ABC 13-12-16 Null

CDE 1-1-15 12-12-15

CDE 13-12-15 Null

i want output

Project_Name Start_Date End_Date

ABC 13-12-16 Null

CDE 13-12-15 Null

vishsaggi — Wed, 15 Mar 2017 16:19:46 GMT

Try this?

LOAD * INLINE [

Project_Name, Start_Date, End_Date

ABC ,12-12-15, 12-12-16

ABC ,13-12-16, Null

CDE ,1-1-15 , 12-12-15

CDE ,13-12-15, Null

]

WHERE End_Date = 'Null';

OR if data is coming from an excel

LOAD Project_Name,

Start_Date,

End_Date

From [..\Desktop\YourexcelFilename.xlsx]

(ooxml, no labels, table is Sheet1)

WHERE End_Date = 'Null';

sunny_talwar — Wed, 15 Mar 2017 16:35:10 GMT

Another option

Table:

LOAD * INLINE [

Project_Name, Start_Date, End_Date

ABC, 12-12-15, 12-12-16

ABC, 13-12-16, Null

CDE, 1-1-15, 12-12-15

CDE, 13-12-15, Null

];

Right Join (Table)

LOAD [Project_Name],

Max(Start_Date) as Start_Date

Resident Table

Group By Project_Name;