topic Re: Expression Help in QlikView

Expression Help

sona_sa — Tue, 07 Aug 2018 10:16:41 GMT

I have a sneriao like this:

I have QVW, Where QVD Name, QVD Size, QVD Time, QVD Size Changed and QVD Time Since Previous Reload filed are available.

I need the % of QVD Size has been increased by last reload to current reload.

Now I need a message alert expression, If the QVD Size Changed from Current QVD Size to Previous Load QVD Size by +10 or -10% Then it should to send the message alert, 'QVD Size is Change by ...... %'.

Can anyone help me on the same.

Thanks.

Re: Expression Help

felipedl — Tue, 07 Aug 2018 11:19:52 GMT

Just add some logging capabilities to the QVW your using to create the QVD.

After you transform / extract, create (and than add more lines to it) a QVD with the number of rows of the newly created QVD file.

So, when you have all the info from last transformation and current, you can load this audit QVD and do the checking you need.

Re: Expression Help

sona_sa — Tue, 07 Aug 2018 11:56:36 GMT

Hi Felip,

Thanks for reply, I am also sharing the xls, from where I am loading the data for same. Can u help me on this. I am not aware with adding the log file data and how to make an expression for the same.

Please find the attached .XLS and .QVW

Regards,

Re: Expression Help

felipedl — Tue, 07 Aug 2018 13:02:37 GMT

Hi,

I so happen to have developed something for my own use for the same situation as yours.

Attached the zip file with what I developed.

RandGenQVD.qvw creates the QVDs to be analyzed and QVD Monitor.qvw gets the info.