topic Re: Create a FLAG dimension OK / NOT based on records in a table in App Development

Create a FLAG dimension OK / NOT based on records in a table

VamsiBhagavathula1 — Wed, 05 Jul 2023 06:44:03 GMT

Hello All,

We record files generated by a process and store them in a table in timestamp level. Now , on qlik app, i want to make a conditional flag if the file got generated at certain time or not and flag it as ok or not okay. In the table, i have the time in the following format

"2023-01-02 19:00:88".

Now, i want to compare if the file got generated with in a sla defined time or not and flag it ??

Note: I dont have the SLA defined time in a table yet.

Best Regards

Vamsi

Re: Create a FLAG dimension OK / NOT based on records in a table

mageste — Tue, 18 Jul 2023 19:57:22 GMT

Hi there!

Could you give some more details?

By the way you said, I understood that you could subtract one timestamp from another and see if it meets the SLA. That could be done creating a new column on the load script, something like:

if(Timestamp_A - Timestamp_B < SLA, 'OK', 'NOT OK') as Flag_SLA

Does this helps or am I missing something?

Re: Create a FLAG dimension OK / NOT based on records in a table

VamsiBhagavathula1 — Wed, 19 Jul 2023 05:00:24 GMT

Hi @mageste , Thanks for looking into it.

i have two time stamps , One is file generation timestamp, second one is SLA timestamp. If the file generation timestamp is not equal to sla time stamp then its not okay, else its okay. i need a flag column like this and when its not okay , i want qlik to send an email alert about the not okay information as a table to the users.

please suggest

Best Regards,

Vamsi