Reduce data in qlikview application

[lavanya14]

Hi Team,

I have a requirement where I need to reduce the data in qlikview application to show only last 15 days of data.

Any suggestions are much appreciated.

thanks in advance.

[Gysbert_Wassenaar]

Select the last 15 days and choose the Reduce data option in the File menu. Then choose the Keep Possible Values option.

[lavanya14]

Hi Gysbert,

Thanks for replying. The application has got last 3 years of data  I automatically want to reduce the data to last 15 days based on the today's date.

Hope this info helps.

Thanks in advance.

[bobbydave]

Load

*

from table.qvd(qvd)

where Date = '$(Today(), -15)'

or to that effect?

This will only load the last 15 days though.

[lavanya14]

Hi David,

Thanks for replying , I had a thought of doing the same thing but the data was reduced as I expected due to some reasons. So I started looking for alternatives.

Could you please suggest if there is any alternatives.

Thanks in advance.

[bobbydave]

It all depends on your dataset. If you are using calendars and calculations that will look for information outside of the last 15 days data set, then what you should only do is make the last 15 days available but you will still need to load everything as the calculations might be using data from before these 15 days.