Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Dated price list

Dear all,

I've a dated price list and for each item, I've to consider the latest starting dates (see excel file in attachment)

How can I solve this problem ?

I'm trying without success for a long time...

Help please

Thanks in advance for your support

1 Solution

Accepted Solutions
Highlighted

Try this:

Table:

LOAD ItmeNr,

    Company,

    Price,

    From,

    To

FROM

PricesOnDate.xlsx

(ooxml, embedded labels, table is Foglio1);

Right Join(Table)

LOAD ItmeNr,

  Max(From) as From

Resident Table

Group By ItmeNr;


Capture.PNG

View solution in original post

4 Replies
Highlighted

Two questions, what do you expect to see? Is this something you want to handle in script or front end of the application or you don't care

Highlighted
Creator II
Creator II

In this case, It' something I want to handle into the script. At the end of the loading, I should have only the yellow lines (see excel file) into my table

Highlighted

Try this:

Table:

LOAD ItmeNr,

    Company,

    Price,

    From,

    To

FROM

PricesOnDate.xlsx

(ooxml, embedded labels, table is Foglio1);

Right Join(Table)

LOAD ItmeNr,

  Max(From) as From

Resident Table

Group By ItmeNr;


Capture.PNG

View solution in original post

Highlighted
Creator II
Creator II

Great !!

It works. Thanks for your help