topic Re: Loading two files from different dates in QlikView

Loading two files from different dates

KaisGarci — Wed, 25 Nov 2020 16:16:04 GMT

Hi everyone,

I am new to qlikview. I have two excel files containing sales of different dates ( week of 07/27 and week of 08/03). I want to create a table that display both sales.

Can anyone help me please ?

Thank you

Re: Loading two files from different dates

dplr-rn — Tue, 11 Aug 2020 14:32:32 GMT

Does the dates change?

Share the names of the files. sample of the contents.

Re: Loading two files from different dates

KaisGarci — Tue, 11 Aug 2020 16:54:48 GMT

Thank you for responding

Yes sales vary from one week to another. I want to put them in a table in order to see the difference.

Re: Loading two files from different dates

dplr-rn — Tue, 11 Aug 2020 17:23:22 GMT

you misunderstood . you mention weeks week of 07/27 and week of 08/03

i am assuming this will change dynamically . is that fair?

if so use a script something like below. (i am assuming you want to load last 2 weeks) i.e. Test 08-03-2020.xls and Test 07-27-2020.xlsx

let vLastWeek = Date(weekstart(today(),0,0)-7,'MM-DD-YYYY'); Sales: LOAD ID, Sales, Date(weekstart(today(),0,0)-7,'MM-DD-YYYY') as Week FROM [..\Downloads\Test $(vLastWeek).xls] (biff, embedded labels, table is Sheet1$); let v2Week = Date(weekstart(today(),0,0)-14,'MM-DD-YYYY'); concatenate(Sales) LOAD ID, Sales, Date(weekstart(today(),0,0)-14,'MM-DD-YYYY') as Week FROM [..\Downloads\Test $(v2Week).xls] (biff, embedded labels, table is Sheet1$);

if you give me the sample excels i can tweak it to your specification

Re: Loading two files from different dates

KaisGarci — Wed, 12 Aug 2020 10:02:55 GMT

Thank you, this loaded sucessfully.

But could you tell me the expression that I have to write to display Sales of this week and sales of previous week ?

To be more simple, I want a table like this:

ID Sales(Week07/27) Sales(Week08/03)

* **** ****

'***' are numbers .

Thank you.

Re: Loading two files from different dates

dplr-rn — Wed, 12 Aug 2020 11:47:13 GMT

You can do that in a pivot table and move week to column.

you could do it script too but i would not recommend it as data model becomes less flexible.

Re: Loading two files from different dates

KaisGarci — Wed, 12 Aug 2020 12:00:58 GMT

Thank you a lot, I will try it