topic Re: pop up - question in QlikView

pop up - question

Wed, 25 Nov 2020 16:16:04 GMT

here is the general idea - I am creating a status page where I get basic statistics of prior day data load.

I am wondering if it is possible to create in QV a pop out msg that would inform user in case load was not complete ( a simple condition if prior day sum of sales is less than last 60 days avg ) that would inform user that data is incorrect?

User would have to close the window to move forward?

is it possible something like that in QV? any similar examples?

Re: pop up - question

saimahasan — Mon, 12 Sep 2016 16:20:56 GMT

You can use Alerts and put the condition of sales<60.

Re: pop up - question

Mon, 12 Sep 2016 16:56:40 GMT

have you seen any simple examples of alert function?

Re: pop up - question

Mon, 12 Sep 2016 18:11:17 GMT

I got it to work. so I get the alert box.

Prior day data is missing for Source Transaction file XXXXXXX from ERP XXXXXX. We will contact IT Person XXXXXX and Business Contact XXXXXXX to resolve the problem.

I am working on text msg and how to make it work.

Re: pop up - question

neelamsaroha157 — Mon, 12 Sep 2016 18:24:28 GMT

Hi Rafal,

Go to Tools --> Alerts or simply by ctrl+Alt+A.

You can add the condition, message as well as the Mail recipient if you want to send the alert mail.

Hope this helps..

Re: pop up - question

vishsaggi — Mon, 12 Sep 2016 20:07:30 GMT

Is this what you looking for?

= 'Prior day data is missing for Source Transaction file' & <YourExpression/Field>XXXXXXX> & 'from ERP' & <YourExpression/Field>XXXXXXX> & '.' & 'We will contact IT Person' & <YourExpression/Field>XXXXXXX> & 'and Business Contact' & <YourExpression/Field>XXXXXXX> & 'to resolve the problem.'

Re: pop up - question

Mon, 12 Sep 2016 20:32:55 GMT

yes - but I cant get it to work with my object.

how do you attach QV file on here so I can show you the object and expressions ?

Re: pop up - question

varshavig12 — Tue, 13 Sep 2016 03:27:02 GMT