Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Problem in using set analysis

Hi,

     I have to show the top 5 Customers based on the Sales.I wanted to show them using a Pie Chart.

    Now this should be insensitive to any selections being made in the Listboxes(i.e..Fields)

    So I put the following Expression : If(Rank(Sum({1} Sales))<=5,Sum({1} Sales)) and Dimension:Customer

 

    This Expression populated the top 5 correctly.But what I need is:

 

    I have a Year Field and a Quarter field and the top 5 should change based on only the Year and the Quarter Selection.

    Please let me know the way forward.

Regards

Navin.G

2 Replies

Problem in using set analysis

Hi,

    Do you mean to say that the expression should be effected only for Year and Quarter filters..?

 

    If yes then you need to pass all other filters in set analysis. Something like this.

    Say you have 5 filers. i.e Field1, Field2 , Field3, Year and Quarter.

    If(Rank(Sum({<Field1 =, Field2 =, Field3 = >} Sales))<=5,Sum({Field1 =, Field2 =, Field3 =} Sales))

Regards,

Kaushik Solanki  

Not applicable

Problem in using set analysis

Hi Kaushik,

                 Your right.I was able to now do it.I have another question

                  I have displayed the Top 5 in this way and now I need to display the Bottom 5 in the Same way.

                  Can you suggest any method to do so?

Regards

Navin.G

Community Browser