topic Re: Top n graph in QlikView

Top n graph

Mon, 14 Jan 2013 23:13:50 GMT

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

Re: Top n graph

Mon, 14 Jan 2013 23:47:07 GMT

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

Re: Top n graph

khadeer — Tue, 15 Jan 2013 04:29:53 GMT

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'

Re: Top n graph

neha_shirsath — Tue, 15 Jan 2013 05:23:36 GMT

Hi,

Please find the attachments , hope it will help you.

Re: Top n graph

Tue, 15 Jan 2013 09:05:02 GMT

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

Re: Top n graph

Tue, 15 Jan 2013 09:09:00 GMT

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

Re: Top n graph

nirav_bhimani — Tue, 15 Jan 2013 09:43:31 GMT

Hi,

Try this Expression

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

Regards,

Nirav Bhimani

Re: Top n graph

neha_shirsath — Tue, 15 Jan 2013 09:53:56 GMT

hi yousseff,

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

Re: Top n graph

Wed, 16 Jan 2013 10:46:38 GMT

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