topic Re: source file is xl? in QlikView

source file is xl?

Anonymous — Wed, 08 Oct 2014 06:25:23 GMT

Hi folks,

My source file is XL it used to get reload only on wednesaday .

my requirement is end user want see the data upto next monday is it possible ?

in clear today is wednesday my file gets reloaded and requirement is end usser want see some sample data upto next monday ?

urgent?

Re: source file is xl?

salto — Wed, 08 Oct 2014 06:38:59 GMT

Hi,

What do you mean with XL? eXtraLarge? Or xls?

If the document gets reloaded today, what is the reason for it not be available by next monday?

Let us know...

Re: source file is xl?

Anonymous — Wed, 08 Oct 2014 06:47:50 GMT

My documents gets reload on only once in week that is wednesday

end user want see expected data early

Re: source file is xl?

Wed, 08 Oct 2014 06:51:29 GMT

Can you explain it clearly?

From what I have understood, Your source file, which is an excel file and gets reloaded every Wednesday. User wants to see data till Monday

1) What exactly does this excel contains data of, nature and all?

2) Does this have transactions of a Week or only for Wednesday or any particular day?

Re: source file is xl?

ashwanin — Wed, 08 Oct 2014 06:57:43 GMT

Hi,

Here it needs to get clear :

Your document uploaded today (8.oct.14). So you want end user will get the data till next monday (13.oct.14) ? or till monday (6.oct.2014)?

Re: source file is xl?

ashfaq_haseeb — Wed, 08 Oct 2014 06:58:57 GMT

Hi,

Do you have publisher with you?

If yes then schedule a reload only task on Wednesday and on monday schedule a Distribute only task.

Hope it helps

Regards

ASHFAQ

Re: source file is xl?

Anonymous — Wed, 08 Oct 2014 07:04:37 GMT

till next monday 13 th oct

Re: source file is xl?

ashfaq_haseeb — Wed, 08 Oct 2014 07:05:55 GMT

did you check my suggestion?

Regards

ASHFAQ

Re: source file is xl?

Wed, 08 Oct 2014 07:20:32 GMT

If its for 13th Oct, why its not available on next Monday as it gets refreshed on Wednesday.

Or the customer wants the data which would be available on 15th Oct on 13th itself?

Re: source file is xl?

Anonymous — Wed, 08 Oct 2014 07:23:06 GMT

No publisher yar

Re: source file is xl?

Anonymous — Wed, 08 Oct 2014 07:24:30 GMT

yes they want see expected data for next moday ? is this possible? or not in qlikview?

Re: source file is xl?

ashfaq_haseeb — Wed, 08 Oct 2014 07:27:27 GMT

A bit trick without publisher.

you need to have a look at windows schedule with .bat file.

wherein you can copy file between folders as per your requirement.

Regards

ASHFAQ

Re: source file is xl?

Wed, 08 Oct 2014 07:30:54 GMT

It depends on the data source, All you can do now is change reload time from Wednesday to Monday, making the data available for Monday.

or Create an Incremental QVD and delay it for a week once and then client would assume that he is getting data early.

But, this none would suggest, I guess.

Re: source file is xl?

ashwanin — Wed, 08 Oct 2014 10:55:07 GMT

If future data is not available in your .xls file then you have to gone through with the predictive analysis .

If future data is available then you need to fix it with the date lock.(bz publisher is not available with you)

Re: source file is xl?

Anonymous — Wed, 08 Oct 2014 10:58:14 GMT

How to do predictive analysis