topic start by a particular month in QlikView

start by a particular month

Tue, 07 Jul 2015 08:40:11 GMT

Hi everybody,

I have a question, i have two strings and i use a calendar as you can see on the left of the screen shot.

So the selection of the date is "01/10/2014" to "30/06/2015", so i want the same table like the screen shot but i want the table start by the first month of the selection (octobre in this selection)

So i would like the field "LVR.mois" start in this case?

Oct

Nov

Dec

Jan

Fev

Mars

Avril

Mai

Juin

How can i do that? thanks a lot!

Re: start by a particular month

Anonymous — Tue, 07 Jul 2015 08:46:35 GMT

Hi,

I think is simplier if you post a sample data.

Regards.

Re: start by a particular month

MK_QSL — Tue, 07 Jul 2015 08:50:01 GMT

You need to use MonthYear instead of Month something like below

Date(MonthStart([Invoice Date]),'YYYYMM') as InvoiceYearMonth;

Re: start by a particular month

lironbaram — Tue, 07 Jul 2015 08:55:38 GMT

hi you could use an expression for the month field sorting

in the sort tab of the chart properties

for the month field check sort by expression

and use this expression : max(Date)

Re: start by a particular month

Tue, 07 Jul 2015 08:56:19 GMT

I post a sample!

thanks a lot

Re: start by a particular month

Wed, 08 Jul 2015 06:59:44 GMT

Up please!

Re: start by a particular month

lironbaram — Wed, 08 Jul 2015 07:10:54 GMT

have a look at the attach example

Re: start by a particular month

avinashelite — Wed, 08 Jul 2015 07:12:28 GMT

Hi Sab,

Go to chrt properties>sort> select the LVR.mois>Expression > and paste this " Min( [LVR.Date d_expédition])"

that will do

Re: start by a particular month

Wed, 08 Jul 2015 07:50:49 GMT

Thanks a lot liron and Avirash it works!!!!!!

Re: start by a particular month

avinashelite — Wed, 08 Jul 2015 08:01:33 GMT

cool if you got the answer mark its helpful and correct