Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Can i use Calculated Column for Interval match

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

1 Solution

Accepted Solutions

Re: Can i use Calculated Column for Interval match

Use this..

5 Replies

Re: Can i use Calculated Column for Interval match

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;

Not applicable

Re: Can i use Calculated Column for Interval match

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.

Not applicable

Re: Can i use Calculated Column for Interval match

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

Re: Can i use Calculated Column for Interval match

Use this..

Not applicable

Re: Can i use Calculated Column for Interval match

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

Community Browser