Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
0li5a3a
Creator III
Creator III

last updates from the table only

Hello,

I need to dislay always the last updates from an excel files. Please find the files attached,

scenario :

Take the latest timestamp data for the month e.g. 28th March

Exclude any data with in blank from Development


I tried already the max and firstsortedvalue but I can't display only the last updates.

Can someone advice me?

Capture.PNG


I want to display only this

            

            

DevelopmentLGPNGPFG5bG5FBRNGFCSSTDFVBORCommentTimestamp
FirstG2Mar-18Sep-18Sep-18£300£250£100£50Greentest327/03/2018 12:04
SecondG3Mar-18Sep-18Sep-18£300£250£100£500test227/03/2018 12:04
ThirdG1Mar-18Sep-18Sep-18£300£250£100£500test127/03/2018 12:04


1 Solution

Accepted Solutions
sunny_talwar

Try this

Table:

LOAD Development,

    LGP,

    NGPF,

    G5b,

    G5F,

    BRNG,

    FCS,

    STD,

    FVB,

    OR,

    Comment,

    Timestamp

FROM

[Test Data.xlsx]

(ooxml, embedded labels, table is Sheet1)

Where Development > 0;


Right Join (Table)

LOAD Development,

Max(Timestamp) as Timestamp

Resident Table

Group By Development;

View solution in original post

2 Replies
sunny_talwar

Try this

Table:

LOAD Development,

    LGP,

    NGPF,

    G5b,

    G5F,

    BRNG,

    FCS,

    STD,

    FVB,

    OR,

    Comment,

    Timestamp

FROM

[Test Data.xlsx]

(ooxml, embedded labels, table is Sheet1)

Where Development > 0;


Right Join (Table)

LOAD Development,

Max(Timestamp) as Timestamp

Resident Table

Group By Development;

View solution in original post

0li5a3a
Creator III
Creator III
Author

Thanks for help, all good using your solution:)