Top n graph

[#1]

Hi,

I need your help, i want do this graph in my dimension i have month and i want display only the Top 10 client

Please,how i can do this ?

Best Regards,

Yousseff

[#2]

Hi Yousseff,

You have to add a Client Dimension on your chart, which QV Version are you working on? because QV 11 has a tab on the chart properties to do the Top 10 thing.

Regards,

Carlos Martinez

[khadeer]

HI,

    Create a variable say vTop. Set it to 10.

    Now create a input box for the same variable. Meaning here user will include the top 'n' value.

    Go to properties of chart -> Sort -> click on the dimension and sort it by 'Y Value'.

    -> Presentation -> at Max Visible No. type '=vTop'

[neha_shirsath]

Hi,

Please find the attachments , hope it will help you.

[#5]

Hi carlosmartinez,

Thank you for your Answer.

I am working with QV 11, i can't produire wath i want if you see my attached i look see the evolution the top 10 client by month.(in my dimension i have month and my expression is

sum({$<

Client={"=rank(Sum({sTop30.M.B<[Year]={'$(vMaxYear)'},[Month]= >}  Amount))<=30"},

[Year]={'$(vMax)'},[Month]=

     >}

     Amount

)

Best Regards,

Emteam

[#6]

Hi,

Thanks All (Neha,QV Learner)  for your answer.

If you see my attached i want put only Month as dimension and my expression is :

sum({$<

Client={"=rank(Sum({sTop30.M.B<[Year]={'$(vMaxYear)'},[Month]= >}  Amount))<=30"},

[Year]={'$(vMax)'},[Month]=

     >}

     Amount

)

There are away to do that ?

Thanks for your help

Yousseff

[nirav_bhimani]

Hi,

Try this Expression

If(AGGR (rank(sum(Amount)), Client) <=10 , Client)

Regards,

Nirav Bhimani

[neha_shirsath · Accepted solution]

hi yousseff,

See the attachment, I done the require changes, Hope this is what you want.

[#9]

Hi Neha,

Excuse me for my late reply as I was on vacation.

Your solution help me and that i want exactly many thanks for your help again

I thank you all for your time

Best Regards,

Yousseff