topic Re: Generate Rank in QlikView

Generate Rank

Mon, 14 Sep 2015 12:14:51 GMT

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

Re: Generate Rank

MK_QSL — Mon, 14 Sep 2015 12:21:53 GMT

Provide sample data!

Re: Generate Rank

jonathandienst — Mon, 14 Sep 2015 12:24:55 GMT

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.

Re: Generate Rank

Mon, 14 Sep 2015 12:28:57 GMT

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,

Re: Generate Rank

Mon, 14 Sep 2015 12:29:18 GMT

Hi, thank you very much for the help.

I have added some information above.

Re: Generate Rank

MK_QSL — Mon, 14 Sep 2015 12:30:26 GMT

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

Re: Generate Rank

Mon, 14 Sep 2015 12:33:27 GMT

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

Re: Generate Rank

jonathandienst — Mon, 14 Sep 2015 12:36:41 GMT

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

Re: Generate Rank

Mon, 14 Sep 2015 12:44:06 GMT

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