topic Re: Bubble size in QlikView

Bubble size

paulwalker — Wed, 25 Nov 2020 16:16:04 GMT

Hi Community,

I have Scatter chart.. I have 2 expressions..

Exp1:

IF(vMin='--Select--' or vMax='--Select--', (Sum({<Month>}LineSalesAmount) / Sum({<Month,Year = {$(=Max(Year)-1)}>}OrderSalesAmount) -1),

if(Sum(LineSalesAmount)>=$(vMin) and Sum(LineSalesAmount)<=$(vMax),

(Sum({<Month>}LineSalesAmount) / Sum({<Month,Year = {$(=Max(Year)-1)}>}OrderSalesAmount) -1)))

Exp2:

Num(1-Sum(LineSalesAmount)/ Sum(OrderSalesAmount))

What should i write expression for Bubble size ??

PFA

Thanks

Re: Bubble size

paulwalker — Tue, 03 May 2016 02:41:21 GMT

I have written for bubble size..

Sum(LineSalesAmount)/ Sum(OrderSalesAmount)

But its not working properly..

I have data 2005 to 2010.. Here comparing data year on year..

when i am click 2005, it should be no data to display.

Re: Bubble size

sunny_talwar — Tue, 03 May 2016 09:06:09 GMT

This

Num(1-Sum(LineSalesAmount)/ Sum(OrderSalesAmount))

or this

Sum(LineSalesAmount)/ Sum(OrderSalesAmount)

both doesn't seem to be year or year. They are going to be values for the selected year. What are you looking to do? May be restrict the above two expression like this:

If(Len(Trim([Target])) > 0,

Num(1-Sum(LineSalesAmount)/

Sum(OrderSalesAmount)))

and

If(Len(Trim([Target])) > 0, Sum(LineSalesAmount)/ Sum(OrderSalesAmount))