Top 2 values from 4 quarters of an year

[#1]

Hi,

Iam new to Qlikview.

Iam trying for following solution.

can anyone of you suggest me.

I have 2 dimensions Year(field1) and Quater(field2)

Iam using Bar chart for with above two dimensions displaying

Sum of Orders per year and per quarter.

i need to display top 2 quater counts in a text box based on selected year.

For example if the data after count of distinct is as below:

Quarter ||  Counts of field3

   Q1     ||      20

  Q2     ||      30

  Q3     ||      40

  Q4     ||      50

We need to display the text as below:

For the year 2013 the top two quaters are Q3 and Q4

Can we get this calculations dynamically when we select the year and coresponding top 2 quarters must be displayed?

Thanks in advance

[tresesco]

It seems that you have to use COUNT and RANK function to get that. the expression depends on the data structure you have. and might have to use ONLY function as well. give a try, read all these functions and try to implement, you would enjoy knowing those for sure.

Thanks.

[#3]

tried but i didnt get solution...

can you give clear solution if any....

thanks