topic Re: TwoMonth period cross in QlikView

TwoMonth period cross

Anonymous — Tue, 09 Feb 2016 10:55:37 GMT

Colleagues, good day!

Is in QV any solution to make field with two moth periods, in which every month includes two periods?

I need to make field (by date field) with such values:

Jan-Feb

Feb-Mar

Mar-Apr

Apr-May

May-Jun

Jun-Jul

Jul-Aug

Aug-Sep

Sep-Oct

Oct-Dec

Dec-Jan

Many thanks for every advice!

Andrey.

Re: TwoMonth period cross

MK_QSL — Tue, 09 Feb 2016 10:57:42 GMT

Have you got date field?

Create something like below..

Dual(Month(Date) & '-' & Month(AddMonths(Date,1)) ,Month(Date)) as YourDualMonthField

Re: TwoMonth period cross

sunny_talwar — Tue, 09 Feb 2016 11:01:25 GMT

Is this This Month - Next Month or Last Month - This Month?

Re: TwoMonth period cross

Anonymous — Tue, 09 Feb 2016 11:05:43 GMT

Yes. I have date field.

Field YourDualMonthField , example (Jan-Feb) get only January dates, but i need Jan & Feb dates

Thanks.

Re: TwoMonth period cross

Anonymous — Tue, 09 Feb 2016 11:05:59 GMT

yes

Re: TwoMonth period cross

sunny_talwar — Tue, 09 Feb 2016 11:11:21 GMT

Which one of the two?

ThisMonth - NextMonth

LastMonth - NextMonth?

Re: TwoMonth period cross

Anonymous — Tue, 09 Feb 2016 11:13:10 GMT

It must be not flag, but field with two month period names.

For example, today date (09.02.2016) must include Jan-Feb and Feb-Mar.

Re: TwoMonth period cross

MK_QSL — Tue, 09 Feb 2016 11:39:27 GMT

Something like below?

Data:

Load * Inline

[

Date, Sales

10/01/2016, 100

25/02/2016, 120

12/03/2016, 90

];

DualMonth:

Load Distinct Date, Month(Date) & '-' &Month(AddMonths(Date,1)) as Flag Resident Data;

Concatenate

Load Distinct Date, Month(AddMonths(Date,-1)) & '-' &Month(Date) as Flag Resident Data;

Re: TwoMonth period cross

Anonymous — Tue, 09 Feb 2016 13:06:06 GMT

It doesn't work.

Re: TwoMonth period cross

jonathandienst — Tue, 09 Feb 2016 13:14:53 GMT

Your dates are text values, not proper date values. Convert them to proper numeric date values and then Manish's logic will work.

When you load the dates, you need something like:

LOAD

...

Date#(Date, 'dd/MM/yyyy') As Date,

...