Show static values in tables

[Aspiring_Developer]

Hello All,

I have below scenario :-

I have one table like this coming from sql:-

Temp:

Report_Date,

Open_wkg_Days,

LOB,

LOGGED_DATE_New

From...

Using these fields, I have created below table in front end:-

dimension : report_date, LOB | meausre - sum(LOGGED_DATE_New)

Now , my problem is that my report is refreshed everyday and it shows number of open issues . Now if the report is refreshed on 10 /03/2021 it shows 99 and 14 . Now when i will open my report next day i.e on 11/03/2021, the number is changing to 25 and 5 due to some open records found in sql and updated the numnber.

My requirement is that i want to keep the historical number static and should not change.

I was thinking of creating a new table using the existing fields and then append it with the original table and then use that field in front. But I am not able to achieve it.

Can anyone please help ?

@sunny_talwar 

[Andrea_Bertazzo]

Hi @Aspiring_Developer 

Thanks for reaching Qlik Community. I am not sure I understand what you need to achieve.

Since the app is uploaded, new data is imported, so it is correct that Sense shows new value. You can see the values of the past days just selecting the day in the Date field.