Grid chart bubble size relative to dimension value

sifatnabil — Tue, 08 Mar 2016 14:29:16 GMT

Hi all,

I have a grid chart where the dimensions are (in order) -

Client,

Week

and Expression -

sum(Sales)

The grid chart is sizing the bubbles based on the highest and lowest values of all clients over the time. What I would like is for the bubble sizing of a client not to be affected by other clients.

So if Sales of client A = $50 (highest for client A), and Sales of client B = $1,000 (highest for client B), the bubble size for both clients should be the same. How can I get this?

Re: Grid chart bubble size relative to dimension value

swuehl — Tue, 08 Mar 2016 14:54:24 GMT

Maybe try something like

=Sum(Sales) / Max(TOTAL<Client> Aggr(Sum(Sales), Client, Week))

topic Re: Grid chart bubble size relative to dimension value in QlikView

Grid chart bubble size relative to dimension value

Re: Grid chart bubble size relative to dimension value