topic Re: Need last 10 days data in QlikView

Need last 10 days data

Thu, 14 Aug 2014 14:48:59 GMT

Hi,

How to display last 10 days data.

Regards,

Manikanta

Thu, 14 Aug 2014 14:53:59 GMT

Please provide more context, some sample data, and/or a sample qvw

maxgro — Thu, 14 Aug 2014 14:57:31 GMT

an example in the attachment

MarcoARaymundo — Thu, 14 Aug 2014 15:28:06 GMT

You can use Object->Properties->Dimension Limits or the Rank function.

Thu, 14 Aug 2014 16:12:10 GMT

Hi,

Use a expression with an interval time using set analysis, something like this:

sum({<MyDateField={">=$(vStartDate) <=$(vEndDate)"}>}SALES)

where you declare two variables (in "Variables Overview") like this:

vEndDate = Max(MyDateField);

vStartDate = ($(vEndDate) -10);

or if you just need last 10 days of all your data limit your table in script:

MyTable_tmp:

LOAD

Field1,

Field2,

FieldN,

MyDateField

From MyData.qvd Order By MyDateField ASC;

Let vDateMax = Num(Peek('MyDateField', -1, 'MyTable_tmp'));

No Concatenate

MyTable:

LOAD

resident MyTable_tmp

Where MyDateField >= ($(vDateMax)-10);

Drop Table MyTable_tmp;

Best regards.