Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
amigo007
Contributor III
Contributor III

Qlik Sense: Displaying data with the maximum date

I need to create a filter on a Qlik Sense dashboard to return the latest result from a table. Let's say I have the follwoing table:

NameSubjectScoreDate
JohnMathematics21.1.2017
MarcMathematics51.1.2017
JohnMathematics315.2.2017
PeterMathematics115.2.2017
JohnMathematics47.3.2017

In this example, John is displayed 3 times for the same subject. How can I make a filter to display only his latest results? i.e. the one on 7.3.2017?

The actual table has hundreds of records, so ideally the filter will display only the latest results for the users having multiple records with similar names and subjects.

5 Replies
laddu_927
Specialist
Specialist

May be like this??

sunny_talwar

You can create a flag in the script

Table:

LOAD Name,

           Subject,

           Score,

           Date

FROM ....;

Left Join (Table)

LOAD Name,

           Subject,

           Max(Date) as Date,

           1 as MaxDateFlag

Resident Table

Group By Name, Subject;

Now to view only the MaxDate information, you can either make a selection in MaxDateFlag or you can use it in your set analysis

{<MaxDateFlag = {1}>}


UPDATE: Modified based on Kushal's response

Kushal_Chawda

just modification to Sunny's script

Left Join (Table)

LOAD Name,

           Subject,

           Max(Date) as Date,

           1 as MaxDateFlag

Resident Table

Group by Name,Subject;

sunny_talwar

Thanks for pointing that out

Larry_Ma
Contributor
Contributor

What if you have a scenarios where you need to pick the max date based on your current selection for each person (not overall)?