topic Re: last 4 date data in Qlik Automate

last 4 date data

inam — Tue, 25 Jul 2023 12:30:46 GMT

Hello Community,

1) I have raw data 1 to 24 July i want only last 4 date data 24,23,22,21. if the today date is 26 so my data is 25,24,23,22 and in Total i want month start to today total data

2) i am using pivot table and i want to solve this in expression.

in Date Created i used below logic but not getting answer

& in expression tab i used below expression

Re: last 4 date data

BrunPierre — Tue, 25 Jul 2023 14:31:13 GMT

Try with this

=Only({$<[Date Created]={">=$(=Date(Max([Date Created])-4,'DD-MM-YYYY'))<=$(=Date(Max([Date Created]),'DD-MM-YYYY'))"}>} [Date Created]))

Re: last 4 date data

inam — Wed, 26 Jul 2023 06:21:46 GMT

Hiii @BrunPierre Thanks for reply.

i tried your logic but not getting answer.

Re: last 4 date data

BrunPierre — Wed, 26 Jul 2023 06:36:16 GMT

My mistake, please try again.

=Aggr(Only({$<[Date Created]={">=$(=Date(Max([Date Created])-4,'DD-MM-YYYY'))<=$(=Date(Max([Date Created]),'DD-MM-YYYY'))"}>}[Date Created]), [Date Created])

Re: last 4 date data

inam — Wed, 26 Jul 2023 06:47:57 GMT

same not getting last 4 days date

Re: last 4 date data

BrunPierre — Wed, 26 Jul 2023 07:01:46 GMT

Could you post the qvw or some data?

Re: last 4 date data

inam — Wed, 26 Jul 2023 07:49:45 GMT

i want last 4 days data and Total is 1st july to last date (25)

PFB qvw

Re: last 4 date data

BrunPierre — Wed, 26 Jul 2023 08:24:05 GMT

[Date Created] is not properly recognized, use this to interpret it.

Date#([Date Created], 'DD-MM-YYYYY') as [Date Created]

Re: last 4 date data

inam — Wed, 26 Jul 2023 09:14:49 GMT

Thanks @BrunPierre for the help \

Date#([Date Created], 'DD-MM-YYYYY') as [Date Created] ...i try this but get ans ...how i solve this only i want last 4 date data and Total is month start to today date,....any other solution how i solve this ?

Re: last 4 date data

BrunPierre — Wed, 26 Jul 2023 13:39:03 GMT

=Aggr(Only({$<[Date Created]={">=$(=Date(Max([Date Created])-3))<=$(=Date(Max([Date Created])))"}>}[Date Created]), [Date Created])

Re: last 4 date data

inam — Wed, 26 Jul 2023 13:50:12 GMT

Hello @BrunPierre Thanks for the help

my qvw 1 column is Report please select TCIL and than apply the logic .....i try your logic now but getting same problem .....if you select TCIL in Tcil JULY data available till date ... so i want last 4 date data and total(MTD achived) is 1st july to 25th july