topic Select the maximum in QlikView

Select the maximum

Fri, 26 Feb 2010 00:13:59 GMT

Hi,

I need to select the last two maximum quarter in the multi box when moved to a particular sheet. My data for quarter will be (Q3'09, Q4'09, Q1'10,Q2'10, Q3'10). and all these are text fields. So, I need to select Q3'10 and Q4'10 automatically when moved to this sheet. I think this should be possible with the help of macro, but I have no idea on how to find the last two maximum.

Thanks

Select the maximum

Fri, 26 Feb 2010 01:31:05 GMT

Hello,

If you are using QV 9.00:

1. Right click on the sheet you want to add the event.

2. Select Sheet Properties.

3. Under the Triggers tab, select Edit Actions (OnActivateSheet).

4. Add the event Select in Field. In Field put the quarter column name. In Search String write: =MaxString(column_name, 1)

... that will give you the max quarter.

5. Add the event Toggle Select. In Field put the quarter column name. In Search String write: =MaxString(column_name, 2)

... that will give you the second max quarter.

When you use Toggle Select, it'll be selected the two maximum quarters.

Steve

Select the maximum

Fri, 26 Feb 2010 04:09:11 GMT

I am using 8.2 version. Is there way of doing it here.