topic Re: Using rank in a chart in QlikView

Using rank in a chart

Fri, 23 Jun 2017 09:10:01 GMT

I show rank for a year as in at textfield:

=aggr(rank(sum({< Frac_counting={'1'}, Period={'2015'}, Region=, Subregion=, Country=, University= >}P),1),University)

Thats works very well for one year.

Then I want to show rank for each year between 2012 and 2015 in a chart.
And then its does not work. And yes I have tried with Period={'2012, '2013', 2014', '2015'} and Period as dimension.

And in addition. Another issue: If I want to show the rank for one particular university then I can't use University={'University of Q'} because when the rank says 1 (and of course - but how to solve this, so I in a chart can show a selected university and a predefined university)

Thanks in advance 🙂

Re: Using rank in a chart

MK_QSL — Fri, 23 Jun 2017 09:12:37 GMT

Where you are using this rank function?

What are the dimensions in your chart/table?

Re: Using rank in a chart

MK_QSL — Fri, 23 Jun 2017 09:16:26 GMT

or try this

aggr(Rank(sum({< Frac_counting={'1'}, Region=, Subregion=, Country=, University= >}P),1),Period, University)

Re: Using rank in a chart

Fri, 23 Jun 2017 09:17:49 GMT

I have used it in a textfield and it show correct the rank of a selected university.

Then I want to show the rank in a line chart. The dimension are year and the expression for the rank is the same as in the textfield ... (I have tried without Period in the SET-analysis and I have tried adding all years but I still only got one dot and not a line)

Re: Using rank in a chart

Anil_Babu_Samineni — Fri, 23 Jun 2017 09:17:52 GMT

Can you try with different Years for same expression and tell us where you are facing issues

Re: Using rank in a chart

MK_QSL — Fri, 23 Jun 2017 09:19:15 GMT

or try this

aggr(Rank(sum({< Frac_counting={'1'}, Region=, Subregion=, Country=, University= >}P),1),University)

aggr(Rank(sum({< Frac_counting={'1'}, Region=, Subregion=, Country=, University= >}P),1),Period)

Re: Using rank in a chart

Fri, 23 Jun 2017 09:24:37 GMT

Thanks, but sorry that returns no data.

Re: Using rank in a chart

MK_QSL — Fri, 23 Jun 2017 09:26:44 GMT

Can you provide few lines of sample data or sample app to work.

Re: Using rank in a chart

Fri, 23 Jun 2017 09:31:33 GMT

Just remove the Period from the set. It should work.

Re: Using rank in a chart

Fri, 23 Jun 2017 09:31:47 GMT

Yes - I try to make a sample and upload - Ill be back 🙂

Re: Using rank in a chart

Fri, 23 Jun 2017 09:43:41 GMT

Ooh - that was a good test. It show me the same dot (at same level) for all seperat years in the line chart (but in the text field the rank changes each year) ... now I have something to investigate more, thanks 🙂

Re: Using rank in a chart

Fri, 23 Jun 2017 09:51:08 GMT

I just tried a bar chart and then its working without Period in the set analysis ... 🙂 🙂 🙂 its near a solution - thank you very much! Maybe I should stay with the Bar chart instead of the Line chart 😉