topic Re: Date based on max row id in App Development

Date based on max row id

New-Qlik — Wed, 22 Dec 2021 16:34:21 GMT

I have to pick date where row_id is maximum .

Date Row_id Message

1/11/2019 12:00:00 1 Data Error

1/11/2019 12:10:00 2 Data Refreshed

I want to display second row . I tried max as script function but didn't work

Thanks

Avneet

Re: Date based on max row id

JordyWegman — Tue, 11 Jun 2019 09:59:20 GMT

Hi Avneet,

Try this:

Table: Load Max(Row_id) as RowFilter, ; Load * Inline [ Date, Row_id, Message 1/11/2019 12:00:00, 1 , Data Error 1/11/2019 12:10:00 , 2 , Data Refreshed ] ; Table: Load Date, Row_id, Message Where Row_id = RowFilter From [YourSource](qvd);

Jordy

Climber

Re: Date based on max row id

New-Qlik — Tue, 11 Jun 2019 12:41:25 GMT

Thanks Jordy for replying , but solution didn't work and also mine is a database table not inline.

Re: Date based on max row id

JordyWegman — Tue, 11 Jun 2019 12:52:39 GMT

Hi Avneet,

The Inline was just an example, you have to get your own database import for this.

You can also work with a variable:

Table: Load Date, Row_id, Message From [YourSource](qvd); tmpTable; Load Max(Row_id) as MaxRowId Resident Table; let vMaxRowId = peek('MaxRowId',0,'tmpTable') TableWithMaxRowId: Load Date, Row_id, Message Where Row_id = $(vMaxRowId) Resident Table;

Jordy

Climber

Re: Date based on max row id

New-Qlik — Tue, 11 Jun 2019 14:20:20 GMT

Thanks . I am trying to show message for max of ROW_ID in an KPI object. Set analysis is not working as message is a text.

Re: Date based on max row id

JordyWegman — Tue, 11 Jun 2019 14:29:30 GMT

Hi,

Then you can just use the variable $(vMaxRowId) in the KPI object.

Jordy

Climber

Re: Date based on max row id

anushree1 — Wed, 12 Jun 2019 05:37:37 GMT

Please check the attached, is this what you are looking for?

Re: Date based on max row id

New-Qlik — Wed, 12 Jun 2019 09:10:09 GMT

Thanks Anushree. It workds wonders in table but when I am trying to create two KPT objects

1. Date =if(Row_id=max(all Row_id),Date)

2. Message =if(Row_id=max(all Row_id),message)

Its not working

Re: Date based on max row id

New-Qlik — Wed, 12 Jun 2019 09:13:07 GMT

Thanks Jordy. IT works for displaying date in KPI

but when I try to display message with Max_row_id = $(vMax_row_id) its give me '-'.

I am not sure where I am wrong

Re: Date based on max row id

JordyWegman — Wed, 12 Jun 2019 09:29:19 GMT

Hi Avneet,

Check you variable overview (left corner) and see if the variable $(vMax_row_id) is returning a value here. If there is no value in here, then you haven't defined your variable well.

Jordy

Climber

Re: Date based on max row id

New-Qlik — Wed, 12 Jun 2019 09:43:30 GMT

Variable overview its says 2 for max_row_id wich is correct and it shows correct for date as well.

But for message it is not. Do KPI shows Text data .

Re: Date based on max row id

JordyWegman — Wed, 12 Jun 2019 09:47:44 GMT

That is good, try to put single quotes around the variable ='$(max_row_id )'

Jordy

Climber

Re: Date based on max row id

anushree1 — Wed, 12 Jun 2019 10:38:16 GMT

Please try the below expression :

=only({<Row_id={$(=max(Row_id))}>}Date)

Re: Date based on max row id

New-Qlik — Wed, 12 Jun 2019 11:05:23 GMT

Thanks it worked.