topic Column Name in Qlik Automate

Column Name

inam — Thu, 27 Jul 2023 12:03:26 GMT

Hello Community

i have data 1st july to 26 july so i want last 4 date data 23,24,25,26 ( if the date is 28 so i want 24,25,26,27 date data ) but i want MTD (Total) is 1st july to today date .

so i create the pivot table and in this table i am using expression below

in dimension

Expression below

expression formula :-

same as all [Date Created] only change -3,-2,-1 so its working fine but i want Actual date instead of name [Date Created]

for example see below format

Expected output

i want Actual date instead of name [Date Created] .

Re: Column Name

cristianj23a — Mon, 31 Jul 2023 16:37:31 GMT

Hello, use this code.

Sum({< [Date Created] = {"$(=Date(Max([Date Created] )-1,'DD/MM/YYYY'))"} >} Sales)

Sum({< [Date Created] = {"$(=Date(Max([Date Created] )-2,'DD/MM/YYYY'))"} >} Sales)

In this code I am considering the previous day, if you want a day before the previous one, you just put -2 and so on.

For each formula you create a definition.

Regarts.

Re: Column Name

marcus_sommer — Tue, 01 Aug 2023 08:56:55 GMT

You need to use an expression for the labels, too. Just deriving the date-part from the set analysis condition - something like: date(now()-n)