topic a bit complicated one in QlikView

a bit complicated one

Alma1234 — Mon, 08 Jul 2013 08:37:18 GMT

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,

Re: a bit complicated one

tresB — Mon, 08 Jul 2013 08:58:29 GMT

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

Re: a bit complicated one

Alma1234 — Mon, 08 Jul 2013 10:28:19 GMT

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 ...

Re: a bit complicated one

tresB — Mon, 08 Jul 2013 11:03:53 GMT

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