topic Re: Expression For Compare the QVD Size BY DateTime in QlikView

Expression For Compare the QVD Size BY DateTime

sona_sa — Wed, 13 Jun 2018 03:39:27 GMT

Hi,

I want to compare my QVD Size on the Behalf of my Last Execution Reload QVD Time to Current Reload time. How I can I do the same.

Fields - QVD Name / QVD Time and QVD Size are available.

FileName	FileSize (KB)	FileTime
v_utprep_history_week.qvd	2,669,441.28	6/13/2018 8:34:13 AM
v_utprep_versions.qvd	1,887,211.67	6/13/2018 8:47:33 AM
v_utprep_issue_func_state_hist.qvd	140,910.47	6/13/2018 8:45:40 AM
v_utprep_history_day.qvd	65,203.75	6/13/2018 8:26:58 AM
v_utprep_issue_base_data.qvd	24,935.20	6/13/2018 8:23:17 AM
v_utprep_issue_kpi_data.qvd	14,340.46	6/13/2018 8:27:58 AM
t-20170822.qvw	6,817.03	8/22/2017 4:59:18 PM
v_utprep_elements.qvd	5,961.13	6/13/2018 8:28:32 AM
v_utprep_history_week.qvd	2,669,441.28	6/12/2018 8:34:13 AM
v_utprep_versions.qvd	1,887,211.67	6/12/2018 8:47:33 AM
v_utprep_issue_func_state_hist.qvd	627,112.03	6/12/2018 8:45:40 AM
v_utprep_history_day.qvd	370,143.26	6/12/2018 8:26:58 AM
v_utprep_issue_base_data.qvd	347,082.66	6/12/2018 8:23:17 AM
v_utprep_issue_kpi_data.qvd	223,539.92	6/12/2018 8:27:58 AM
t-20170822.qvw	196,836.50	8/22/2017 4:59:18 PM
v_utprep_elements.qvd	3,396.22	6/12/2018 8:28:32 AM
v_utprep_history_week.qvd	2,669,441.28	6/15/2018 8:34:13 AM
v_utprep_versions.qvd	1,887,211.67	6/15/2018 8:47:33 AM
v_utprep_issue_func_state_hist.qvd	627,112.03	6/15/2018 8:45:40 AM
v_utprep_history_day.qvd	370,143.26	6/15/2018 8:26:58 AM
v_utprep_issue_base_data.qvd	347,082.66	6/15/2018 8:23:17 AM
v_utprep_issue_kpi_data.qvd	223,539.92	6/15/2018 8:27:58 AM
t-20170822.qvw	196,836.50	8/22/2017 4:59:18 PM
v_utprep_elements.qvd	140,910.47	6/15/2018 8:28:32 AM

Please look into and let me any expression for the same.

Regards,

Re: Expression For Compare the QVD Size BY DateTime

sona_sa — Wed, 13 Jun 2018 06:42:55 GMT

Any Solution, May I expect from anyone.

Regards,

Re: Expression For Compare the QVD Size BY DateTime

Miguel_Angel_Baeyens — Wed, 13 Jun 2018 06:49:10 GMT

Assuming the table in your post, what is the outcome you expect?

Re: Expression For Compare the QVD Size BY DateTime

sona_sa — Wed, 13 Jun 2018 07:16:03 GMT

I want when my QVD Size Increase or decrease at the next time reload from the current size or File Time, That QVD Information I need in line graph or bar graph.

Regards,

Re: Expression For Compare the QVD Size BY DateTime

sona_sa — Wed, 13 Jun 2018 07:57:57 GMT

Hi Miguel,

Suppose, If I am reloading my application after 4 Hr., So I want the DateTime, Size of QVD, If there is any changes has been done from previous reload.

Means Compare of New QVD Size and Reload Time.

Please help on this. Urgent.

Regards,

Re: Expression For Compare the QVD Size BY DateTime

vardhancse — Wed, 13 Jun 2018 09:06:23 GMT

Hi,

In order to know the latest time stamp in a QVD use below logic:

**we need to have one primary key and date field in the data source

if isnull(QvdCreateTime('\Fact.qvd')) THEN //Check if QVD is existing or not, if not then full reload

Sample:

Load

column1,

Date,

Column2

From

(ooxml, embedded labels, table is sheet1) ;

Store Fact into \Fact.qvd;

Drop Table Fact;

ELSE

MaxDate:

LOAD Max(Date_ID) as MaxDateQVD //Identify Max date from existing QVD

FROM

\Fact.qvd

(qvd);

Let vMaxDate = Date(Peek('MaxDateQVD')); //Variable to load the maxdate from QVD

Drop Table MaxDate;

and then in table use where condition some thing like below:

Sample:

Load

column1,

Date,

Column2

From

(ooxml, embedded labels, table is sheet1) where Date > $(vMaxDate);

Cocatenate(Fact)

Load

column1,

Date,

Column2

From

\Fact.qvd(qvd) where NOT Exists(Primary key);

Store Fact into Fact.qvd;

Draop Table Fact;

END IF;

Re: Expression For Compare the QVD Size BY DateTime

sona_sa — Wed, 13 Jun 2018 09:51:54 GMT

Hi Rithi,

Where is sheet1, Can u explain :

Sample:

Load

column1,

Date,

Column2

From (ooxml, embedded labels, table is sheet1) ;

Store Fact into \Fact.qvd;

Drop Table Fact;

Regards,

Re: Expression For Compare the QVD Size BY DateTime

sona_sa — Wed, 13 Jun 2018 10:10:40 GMT

Hi Varaha,

Please let me know if I have Original QVD like this :

Summary:

LOAD [QVD Path],

[QVD Size (KB)],

[QVD Time],

[QVD DateNum],

[QVD Name],

[QVD Folder Name]

FROM [$(vPath)*.qvd](qvd);

Data is like - :

Please find the attached Data.xls.

Now I can implement the Comparison between same QVD by Time and Size. in Graph. I want to check what are the QVD is increased or decreased by Current DateTime Reload. Difference between last reload QVD Size and Current Reload QVD Size.

Regards,

Re: Expression For Compare the QVD Size BY DateTime

sona_sa — Wed, 13 Jun 2018 13:27:24 GMT

Hi,

Ok, I am explaining :

I have Original QVD like this :

Summary:

LOAD [QVD Path],

[QVD Size (KB)],

[QVD Time],

[QVD DateNum],

[QVD Name],

[QVD Folder Name]

FROM [$(vPath)*.qvd](qvd);

Data is like - :

Please find the attached Data.xls.

Now I have to implement the expression for Comparison between same QVD by Time and Size. in Graph. I want to check what are the QVD is increased or decreased by Current DateTime Reload to previous loaded QVD. Difference between last reload QVD Size and Current Reload QVD Size.

Regards,

Re: Expression For Compare the QVD Size BY DateTime

sona_sa — Wed, 13 Jun 2018 15:22:51 GMT

Any Conclusion friends.

Regards,