topic Re: Can i use Calculated Column for Interval match in QlikView

Can i use Calculated Column for Interval match

Thu, 09 Jul 2015 09:32:27 GMT

Hi Friends

I need to use a Calculated Column for interval match. I attached my script here. It execute with out error. But I Can't get the association b/w the interval match and my Calculated column

Re: Can i use Calculated Column for Interval match

MK_QSL — Thu, 09 Jul 2015 09:35:27 GMT

May be try this

Sales:

LOAD [Order ID],

Year,

[Order Date],

[Employee ID],

Status,

[Customer Name],

[Product ID],

[Shipped Date],

[Shipping Fee],

Taxes,

[Order Total],

Interval(Date(Floor([Shipped Date]))-Date(Floor([Order Date])),'D') as Days

FROM

[\\f-typhon\home2$\z014261\MyDocs\Sales Orders1.xls]

(biff, embedded labels, table is [Order List$]);

Inter:

LOAD * INLINE [

Start, End, Order

2, 5, Order1

6, 10, Order2

11, 15, Order3

16, 20, Order4

21, 25, Order5

26, 31, Order6

];

Inner Join

IntervalMatch(Days, [Order ID])

LOAD Start, End, [Order ID] Resident Inter;

Re: Can i use Calculated Column for Interval match

Thu, 09 Jul 2015 09:45:23 GMT

Inner Join

IntervalMatch(Days, [Order ID])

LOAD Start, End, [Order ID] Resident Inter;

Manish it raise exception.. I didn't use that column in Inter table.

Re: Can i use Calculated Column for Interval match

Thu, 09 Jul 2015 09:47:16 GMT

Brother am really sorry I got my Output really Thankyou very much

Re: Can i use Calculated Column for Interval match

MK_QSL — Thu, 09 Jul 2015 09:49:53 GMT

Use this..

Re: Can i use Calculated Column for Interval match

Thu, 09 Jul 2015 09:52:27 GMT

Really awesome dude............