Show static values in tables

Aspiring_Developer — Tue, 22 Mar 2022 12:10:13 GMT

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

Re: Show static values in tables

Andrea_Bertazzo — Fri, 01 Apr 2022 15:25:40 GMT

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.

topic Re: Show static values in tables in App Development

Show static values in tables

Re: Show static values in tables