topic Re: Week in QlikView

Week

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

Hi Experts,

How can i get last &first 3 weeks data.

Regards,

Mahesh.

Re: Week

sunny_talwar — Thu, 09 Jun 2016 17:02:59 GMT

In the script or an expression?

Re: Week

qlikview979 — Thu, 09 Jun 2016 17:05:35 GMT

Hi Sunny,

I have date field, i need in script level. please can you share with expression also.

Regards,

Mahesh.

Re: Week

sunny_talwar — Thu, 09 Jun 2016 17:07:55 GMT

One more question, what do you mean when you say last and first 3 week date? So 3 weeks from beginning or your data and 3 weeks to the end of your data

Re: Week

qlikview979 — Thu, 09 Jun 2016 17:10:53 GMT

Hi Sunny,

3 weeks to the end of my data.

Regards,

Mahesh.

Re: Week

sunny_talwar — Thu, 09 Jun 2016 17:20:25 GMT

I am not 100% sure I understand, can you share some raw data with the expected output?

Re: Week

qlikview979 — Thu, 09 Jun 2016 17:25:32 GMT

Hi Sunny,

please find my attached file.

Here i want 9-31 dates sales(3 weeks).

Regards,

Mahesh.

Re: Week

sunny_talwar — Thu, 09 Jun 2016 17:31:33 GMT

Try this:

Temp:

LOAD Max(weeks) - 22 as Max

FROM

WEEKS.xlsx

(ooxml, embedded labels, table is Sheet1);

LET vPick = Peek('Max', 0, 'Table');

DROP Table Temp;

Table:

Directory;

LOAD ID,

weeks,

Sales

FROM

WEEKS.xlsx

(ooxml, embedded labels, table is Sheet1)

Where weeks >= $(vPick);

Re: Week

qlikview979 — Thu, 09 Jun 2016 17:38:43 GMT

Hi Bro,

Superb ,It 's working perfectly.

I need your one more help i want to change dynamically based on date field.

Regards,

Mahesh.

Re: Week

sunny_talwar — Thu, 09 Jun 2016 17:40:22 GMT

This is dynamic based on the date field. This will always bring in the most recent 3 weeks based on the maximum date available in your database

Re: Week

qlikview979 — Thu, 09 Jun 2016 17:45:38 GMT

Hi Bro,

Thanks for your support.

Regards,

Mahesh.