Calculating a dimension to show Highest Month and Lowest Month Values

[#1]

I have a table with values in. I'd to show the highest month and lowest month

Orig Table

Type Apr-14 May-14 Jun-14 Jul-14 Aug-14 Amendments & Changes 313 84 901 0 375 Billing 2831 1675 8754 508 1507 Direct Debits 2551 2635 9790 571 2795 Leaving 18 82 257 0 164 Meters 221 196 1751 316 572 Moving Home 217 415 1611 0 77 Online Account 281 550 2133 241 787 Other 664 634 2921 348 652 Payments 2380 1584 7913 458 1190 Readings 1797 1342 7251 907 2274 Switching 16 179 609 70 83 Tariffs 1658 741 3279 380 1762 Unknown 718 16 920 0 0

New Table Required

	High	Low
Amendments & Changes	Jun-14 (901)	Jul-14(0)
Billing	Apr-14 (2831)	Jul-14(508)
Direct Debits	Jun-14 (9790)	Jul-14(571)

(Just first 3 lines shown to illustrate, need all lines including)

I've had a play around with the Rank and Aggr functions but haven't had much luck. Can anyone help?

[MarcoWedel · Accepted solution]

Hi,

one possible solution:

table1:
CrossTable (MonthText, Value)
LOAD *
FROM [http://community.qlik.com/thread/131165]
(html, codepage is 1252, embedded labels, table is @1);

Left Join (table1)
LOAD Distinct
  MonthText,
  Date#(MonthText, 'MMM-YY') as Month
Resident table1;

hope this helps

regards

Marco