Bubble Chart help

[ericdelaqua]

Hi Everyone,

It is my first assistance request in this community. I have just started trying out Qlikview for my company and my first challenge is below.

The sample data below is only showing 1 shop_id out of thousands. What I would like to achieve is a bubble chart that shows the score average of each ITEM_CD by the count ITEM_CD in any particular month.

The expected result will show in the month the percentage of each ITEM_CD and the total ITEMS for the month. We can also visually see Where both mandatory and non-mandatory were sold in the month.

I have attached an excel sample below.

Thanks a lot in advance for you assistance.

Eric

[Anil_Babu_Samineni · Accepted solution]

Like this