Discussion Board for collaboration on QlikView Layout & Visualizations.
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
Go to Solution.
May be try this
LOAD [Order ID],
Interval(Date(Floor([Shipped Date]))-Date(Floor([Order Date])),'D') as Days
(biff, embedded labels, table is [Order List$]);
LOAD * INLINE [
Start, End, Order
2, 5, Order1
6, 10, Order2
11, 15, Order3
16, 20, Order4
21, 25, Order5
26, 31, Order6
IntervalMatch(Days, [Order ID])
LOAD Start, End, [Order ID] Resident Inter;
Manish it raise exception.. I didn't use that column in Inter table.
Brother am really sorry I got my Output really Thankyou very much
Really awesome dude............