a bit complicated one

[Alma1234]

Hello,

I have orders table: order_id, date, profit

I need to have a table each day a week what is the maximum profit, but without duplicates days.

Meaning that if in year 2000 the max day is Monday and in Year 2001 also the max day is Monday that in year 2001 i will take the second max day for profit and extra.

Thanks,

[tresesco]

I guess you can make it a bit less complicated by explaining it better.

Have a look here : http://community.qlik.com/docs/DOC-2380

[Alma1234]

oK ,thanks

I have a table of orders:

Load * inline{

Index_Order_ID, Order_Date, Profit

1, 1/1/2010,40

2,4/1/2010, 1200

3, 5/1/2010, 800

4, 7/3/2011, 1000

6, 4/3/2011, 900

}

from this table i made a new table by group by for maximum profit:

Year, Day

2010, Monday

2011, Monday

Now if 2010 already have Monday for the profitable year, i can't have 2011 as Monday as well

I need to find out which day a week is the second maximum day for 2011

And so on for all the others years.

Hope it is more clear ...

[tresesco]

In that case, you would have maximum seven years data. Is it so?