Selection Box: Revenue Ranges

Tue, 04 Oct 2011 23:23:32 GMT

Hi All,

I have an excel with records of companies, regions, employees and revenues with 400.000+ records.

I want to create selection box with revenue ranges to be able to see wich companies fall between a given revenue range.

Wich is the best way to achieve my goal?

Thanks in advance.

David

Wed, 05 Oct 2011 00:02:25 GMT

Are revenues already aggregrated?

If so, you could use interval match.

///Assume a table with the field Revenue already exists and the following should make sense

inner join intervalmatch (Revenue)

LOAD * INLINE [

START, END, Revenue

0, 10, 0 - 10

11, 20, 11 - 20

21, 30, 21 - 30

31, 40, 31 - 40

41, 50, 41 - 50

51, 60, 51 - 60

61, 70, 61 - 70

71, 80, 71 -80

81, , 81 +

];

If you don't have revenue aggregated in script, you could use set analysis with variables.

My set analysis skills are limited but I am sure there are examples around.

topic Selection Box: Revenue Ranges in QlikView