topic Reduce data in qlikview application in QlikView

Reduce data in qlikview application

lavanya14 — Thu, 21 Jun 2018 10:21:17 GMT

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.

Re: Reduce data in qlikview application

Gysbert_Wassenaar — Thu, 21 Jun 2018 10:31:39 GMT

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

Re: Reduce data in qlikview application

lavanya14 — Thu, 21 Jun 2018 10:38:26 GMT

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.

Re: Reduce data in qlikview application

bobbydave — Thu, 21 Jun 2018 10:48:56 GMT

Load

from table.qvd(qvd)

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

or to that effect?

This will only load the last 15 days though.

Re: Reduce data in qlikview application

lavanya14 — Thu, 21 Jun 2018 11:15:17 GMT

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.

Re: Reduce data in qlikview application

bobbydave — Thu, 21 Jun 2018 11:22:43 GMT

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.