Generate Rank

[#1]

Hi there,

Can you help me?

I have a table showing: Page Name + Page Views.

I would like to be able to dynamically calculate the rank of that page each time a filter is applied.

So, if the user selects the section "news", can I automatically calculate a rank for that page, based on the number of pageviews?

Thanks

[MK_QSL]

Provide sample data!

[jonathandienst]

You have not supplied any information about the expression for which you want help, so all I can say is to look up the rank function in the help and in the reference manual or search the communiity.

[#4]

Hi,

Sorry I didn't provide enough detail.

I have the data at the bottom of the sheet which says Fund name and pageviews.

Essentially, if the user selects a particular sector (using the search box), we should see a rank for the FundName (based on the number of pageviews).

To do this, I also need to know how to aggregate all pageviews so I only get one line per fundName. At the minute, it pulls in several rows due to the date field,

[#5]

Hi, thank you very much for the help.

I have added some information above.

[MK_QSL]

Could you provide some sample or dummy date to work on?

[#7]

Sure - here is some sample data. I hope it's possible to export from here

I need to aggregate pageviews & generate a rank dependant on which sector is selected if possible

fundCode	fundName	Pageviews
00F4R	Marlborough Multi Cap Income	3
00F4R	Marlborough Multi Cap Income	7
00F4R	Marlborough Multi Cap Income	10
00F4R	Marlborough Multi Cap Income	13
00F4R	Marlborough Multi Cap Income	16
00F4R	Marlborough Multi Cap Income	20
00F4R	Marlborough Multi Cap Income	23
00F4R	Marlborough Multi Cap Income	26
00F4R	Marlborough Multi Cap Income	29
00F4R	Marlborough Multi Cap Income	33
00F4R	Marlborough Multi Cap Income	36
00F4R	Marlborough Multi Cap Income	39
00F4R	Marlborough Multi Cap Income	42
00F4R	Marlborough Multi Cap Income	46
00F4R	Marlborough Multi Cap Income	49
00F4R	Marlborough Multi Cap Income	55
00F4R	Marlborough Multi Cap Income	62
00F4R	Marlborough Multi Cap Income	65
00F4R	Marlborough Multi Cap Income	68
00F4R	Marlborough Multi Cap Income	72
00F4R	Marlborough Multi Cap Income	75
00F4R	Marlborough Multi Cap Income	81
00F4R	Marlborough Multi Cap Income	85
00F4R	Marlborough Multi Cap Income	91
00F4R	Marlborough Multi Cap Income	94
00F4R	Marlborough Multi Cap Income	101
00F4R	Marlborough Multi Cap Income	104
00F4R	Marlborough Multi Cap Income	107
00F4R	Marlborough Multi Cap Income	114
00F4R	Marlborough Multi Cap Income	117
00F4R	Marlborough Multi Cap Income	124
00F4R	Marlborough Multi Cap Income	133
00F4R	Marlborough Multi Cap Income	137
00F4R	Marlborough Multi Cap Income	140
00F4R	Marlborough Multi Cap Income	143
00F4R	Marlborough Multi Cap Income	211

[jonathandienst]

Regrettably your nice screenshot is basically useless. Manish' suggestion was to supply sample data (and I would add a sample qvw file).

[#9]

How do I go about uploading a qvw file in this editor?