topic Re: 1 dimension 3 Expression in QlikView

1 dimension 3 Expression

boopeshj — Tue, 15 Dec 2015 07:33:59 GMT

Hi ,

I have to create a bubble chart with No of Stores in x axis , Sales in Y axis and the size of the bubble with the Number of Transactions.

Please let me know how to do this.

Thanks

Boopesh

Re: 1 dimension 3 Expression

Gysbert_Wassenaar — Tue, 15 Dec 2015 16:11:30 GMT

You can use a scatter chart for this with three expressions:

Count(distinct Stores)

Sum(Sales)

Count(distinct Transactions)

I have no idea what you want to use as dimension. You haven't given any information regarding that.

Re: 1 dimension 3 Expression

boopeshj — Wed, 16 Dec 2015 08:19:08 GMT

My Dimension would be Region. Where one Region will have many Stores.

And the question is how to determine that the size of the bubble is to be on Transaction count. ?

Re: 1 dimension 3 Expression

Anonymous — Wed, 16 Dec 2015 08:26:37 GMT

Combo Chart is also a option

Re: 1 dimension 3 Expression

Wed, 16 Dec 2015 08:28:40 GMT

Hi boopesh ,

if you want more detail about Scatter chart

Creating a Scatter Chart

Re: 1 dimension 3 Expression

Anonymous — Wed, 16 Dec 2015 10:18:20 GMT

Its upto Business requirement and Users...

1) Bubble size can be defiend on the base of Sales like =sum(Sales)

2) Bubble size can be defiend on the base of number of transaction like =Count(TransactionID) or Count(TransactionDate) //use distinct if required

3) Bubble size can be defiend on the base of Stores like =Count(StoreID) //Use distinct if required