Expression For Compare the QVD Size BY DateTime

[sona_sa]

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,

AK

[sona_sa]

Any Solution, May I expect from anyone.

Regards,

AK

[Miguel_Angel_Baeyens]

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

[sona_sa]

Hi

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,

AK

[sona_sa]

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,

AK

[vardhancse]

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;

[sona_sa]

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,

AK

[sona_sa]

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,

AK

[sona_sa]

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,

AK

[sona_sa]

Any Conclusion friends.

Regards,

AK