Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Partner
Partner

Bucket Wise Bar Graphs to Show Top 'N'

Hi All,

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

SellerSales
Andy100
Smith150
John80
Brent60
Dan200
Scott250
Kenny180
Dick70
Paul90
Bell120
Chris150
Mitchel130
Cook50
Corey210
Bravo140
George240
Mark110
Steve190
Chet160
Peter220
Tom170

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!

Tags (1)
1 Solution

Accepted Solutions
Highlighted
MVP
MVP

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

8 Replies
Highlighted
Contributor III

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

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

Highlighted
MVP
MVP

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

like this?

1.png

Highlighted
Partner
Partner

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

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.

Highlighted
Partner
Partner

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

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!

Highlighted
MVP
MVP

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

Highlighted
Partner
Partner

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

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?

Highlighted
MVP
MVP

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

just an idea

1.png

Highlighted
Partner
Partner

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

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

I will check on your suggestions.

God Bless!!!