Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Join condition - date interval

hi everyone!

Please help me with this question!!

The table 'A' has the code and the sale date of an item. The table 'B' has all the input item in inventory and its cost.

I need to return the average cost of an items between a date interval.

How can I handle when i need to work with date interval?

In the following example I know that the syntax is not correct. Just want to transmit the intention.

:

LOAD

[COD],

[SALE DATE],

FROM

[MATERIAL.qvd]

(qvd);

LEFT JOIN

LOAD

[COD],

[INPUT DATE],

Sum([VL_TOTAL_ITEM_NF])/ Sum([QT_ITEM_ESTOQUE] * [QT_CONV_ESTOQUE_CONSUMO]) as [Average Cost]

Resident

Where [INPUT DATE] <= [SALE DATE]

and [INPUT DATE] >= [SALE DATE - 180];

Tags (3)
1 Solution

Accepted Solutions

Re: Join condition - date interval

Ciao,

l'istruzione che fa al tuo caso è intervalmatch, guarda l'help, è semplice da usare.

------------------

Hallo

you need intervalmatch instruction, look help guide. it's easy to use!

2 Replies

Re: Join condition - date interval

Ciao,

l'istruzione che fa al tuo caso è intervalmatch, guarda l'help, è semplice da usare.

------------------

Hallo

you need intervalmatch instruction, look help guide. it's easy to use!

Not applicable

Re: Join condition - date interval

Thank you Alessandro!!

Community Browser