topic Re: Bucket Wise Bar Graphs to Show Top 'N' in QlikView

Bucket Wise Bar Graphs to Show Top 'N'

dmohanty — Mon, 15 Sep 2014 20:04:49 GMT

Hi All,

I have a data sheet (for example) like this below:

Seller	Sales
Andy	100
Smith	150
John	80
Brent	60
Dan	200
Scott	250
Kenny	180
Dick	70
Paul	90
Bell	120
Chris	150
Mitchel	130
Cook	50
Corey	210
Bravo	140
George	240
Mark	110
Steve	190
Chet	160
Peter	220
Tom	170

REQUIREMENT:

Now in a Bar Graph, I need to show Bucket Wise Data for the Top Seller(Top 1), Top 5, Top 10 and Top 15 Sellers in 4 Bars, and with their Count and % of contribution to the Total Sales (i.e 3070).

Could someone show me with an example with this data? It would be really appreciated.

Regards!

Re: Bucket Wise Bar Graphs to Show Top 'N'

Anonymous — Mon, 15 Sep 2014 20:24:33 GMT

Check the solution of dynamic top/bottom in the file attached

Re: Bucket Wise Bar Graphs to Show Top 'N'

maxgro — Mon, 15 Sep 2014 20:47:18 GMT

like this?

Re: Bucket Wise Bar Graphs to Show Top 'N'

dmohanty — Mon, 15 Sep 2014 20:54:35 GMT

Hye Massimo,

Greetings!

I guess the image you have displayed is my actual solution. many thanks.

Could you please help more on this by sharing the app?

Really appreciated.

Re: Bucket Wise Bar Graphs to Show Top 'N'

dmohanty — Mon, 15 Sep 2014 20:55:31 GMT

Hi Kozins,

Thank you.

It helped me somehow, but I wanted my Top 5, Top 10 etc to be clubbed into a single single bar.

Regards!

Re: Re: Bucket Wise Bar Graphs to Show Top 'N'

maxgro — Mon, 15 Sep 2014 21:13:58 GMT

PFA

Re: Bucket Wise Bar Graphs to Show Top 'N'

dmohanty — Mon, 15 Sep 2014 21:23:18 GMT

Many a Thanks Massimo.

It was really helpful. One more request I have, if you can help.

Can it be possible somehow to display the names of the Sellers (somehow) on each Bars.

Something if we hover the mouse or by any means?

Re: Bucket Wise Bar Graphs to Show Top 'N'

maxgro — Mon, 15 Sep 2014 21:41:18 GMT

just an idea

Re: Bucket Wise Bar Graphs to Show Top 'N'

dmohanty — Mon, 15 Sep 2014 21:43:13 GMT

Thanks a lot again Massimo for quick help. It was really appreciated.

I will check on your suggestions.

God Bless!!!