topic Date Range in QlikView

Date Range

Tue, 11 Jan 2011 06:05:39 GMT

Hi,

I have one table to show the validation date for order.

Orders:
load * Inline
[StartDate,EndDate,OrderId
'2010-10-01','2010-12-01',1
'2010-05-01','2010-07-01',2
]

I want to use a table object to show how many valid orders based on month.

For example:

2010-6 1

2010-11 1

How to achieve it without changing the script.

Thanks.

lironbaram — Tue, 11 Jan 2011 08:27:16 GMT

hei attach is an example

it changes a little bit the script

but the use of interval match is excatly what you asked for

hope its helps you

Tue, 11 Jan 2011 08:37:47 GMT

Sorry, could you paste the scipt directly, we just buy Named call not client version, so I can not open it.

lironbaram — Tue, 11 Jan 2011 08:38:59 GMT

orders:

LOAD

OrderId

StartDate

EndDate

FROM

(

ooxml, embedded labels, table is ??????1)

;

datelist:

load

date(today()-rowno()) as Date

year

(today()-rowno()) & '-' & num(month(today()-rowno()),'00') as

MonthYear

autogenerate

3000

;

lironbaram — Tue, 11 Jan 2011 08:40:57 GMT

hei attach is a text file with the script