topic flag/marker set by user-trigger/macro in QlikView

flag/marker set by user-trigger/macro

Tue, 28 May 2013 06:59:37 GMT

Hello community,

hope I landed in the right section.

I have to deal with the following user request:

There are several departments which send in reports for each week (these get imported to the db).

Now, one key user checks the whole qlikview report for missing or wrong data each week. For examle one department's data is missing this week or put in wrong information.

If everything is fine he wants to set some sort of flag (checkmark) indicating that the qlikview report for this specific week (over all departments) has been checked, so that he can then inform other users that they can now work with the data (printing, etc.). Basically a green checkmark vs. a red alert image for each week.

So, I believe I need some sort of "user trigger" to update the qlikview document but how and where could I store the flag information?

How would you solve this request? Maybe it's a common task but I couldn't find any information on it. All I can think of is a stored procedure modifying a table record but maybe there is a better (easier) way, perhaps directly inside Qlikview with the help of macros.

Hoping for your ideas.

Thanks for you help,

Thorsten

Re: flag/marker set by user-trigger/macro

Gysbert_Wassenaar — Tue, 28 May 2013 07:41:12 GMT

I think you can use annotations for what you want. See here for some information.

Re: flag/marker set by user-trigger/macro

Tue, 28 May 2013 08:06:32 GMT

this really is a simple way 🙂

But I think I should go for a more flexible solution approach.

Re: flag/marker set by user-trigger/macro

Gysbert_Wassenaar — Tue, 28 May 2013 08:25:32 GMT

Maybe a Dynamic Update action. See the help file for more information.

Re: flag/marker set by user-trigger/macro

Tue, 28 May 2013 11:30:25 GMT

any more infos on that? Where does the dynamic update take place?