topic Re: Problem with rolling data in QlikView

Problem with rolling data

kishorj1982 — Sun, 10 Dec 2017 06:38:31 GMT

hi All,

we have rolling data.For every month we are getting the flat files related to respective month.But sometime for current month file is getting delayed by 5-10 days.

Apparently ,data will not be displayed if data for that month is not there.But client still needs to view the data.

Can you please suggest the possible solution to this.

Thanks

Re: Problem with rolling data

Anil_Babu_Samineni — Sun, 10 Dec 2017 08:02:08 GMT

May be look Master calendar to get all missed months , Dates ...

Re: Problem with rolling data

luismadriz — Mon, 11 Dec 2017 05:12:20 GMT

Hi,

You're saying that old data is not being displayed when the current month data hasn't been uploaded?

In other words, data is only be displayed if the current month data is present?

Is that's the case, I think there must be calculations done against current month instead of max(month)...

But difficult to say without more information. Can you share more information about the data calculation?

Cheers,

Luis

Re: Problem with rolling data

neha_shirsath — Mon, 11 Dec 2017 07:38:24 GMT

Apparently ,data will not be displayed if data for that month is not there.But client still needs to view the data-

This means unless and until new data file get uploaded till then user want to see old data ?

Re: Problem with rolling data

kishorj1982 — Mon, 11 Dec 2017 07:43:03 GMT

Yeah.

Re: Problem with rolling data

neha_shirsath — Mon, 11 Dec 2017 07:56:28 GMT

What expression/logic you are using to update new file?

Might be you are considering today's date or current month logic instead of that use max(date) in your expression.