RE:Range

[Chanty4u]

hi all,

i hve a list box wit ranges like

-

les dan 1k

1-4k

5-9k

likdat and i hve a map ..

my reuirment is:  i alrdy gven colur coding  bt if i select nul value,or <1k   it is gvng same size of bubble selection

so i want   increase in bouble size based on selection 

so please help me on this.

thank you

suresh

[qlikviewwizard]

Hi Suresh,

Really I did not understand your issue.

Please elaborate?

[Chanty4u]

okay.

My req is    if we select '-'   nul symbol in list box ....it show starting size..whereas selecting next values size of bubble also increase.

wen i select multiple values it is showing same size.

example  :1-4k   is one size

5-9k is othr size

i want if i select both  it wil show different sizes ..

hope u can u.stnd

[jagan · Accepted solution]

Hi Suresh,

I am not getting your requirement, in the attached screenshot you can see one big bubble and many small bubbles on it.

The big bubbles are BPCE and Credit Agricole (names) with values 10500 and 10008 and all remaining names are having very less values i.e, 20 to 255.  The difference is huge so you are seeing very small bubbles.

If you exclude this two names BPCE and Credit Agricole then you can see the varying bubbles clearly.

Hope this helps you.

If you got the answer please close this thread by giving Correct and Helpful answers to the useful posts.

Regards,

Jagan.

[qlikviewwizard]

Why you are selecting NULL values from ListBox? We can eliminate those by using len function.

if(IPGKRANGE ='-',Dual('-',1),

I think the above one is not needed.

[Chanty4u]

Tanq jagan and qlikviewwizard)

[qlikviewwizard]

Hi Suresh,

Please select correct and Helpful answers to close this thread. Thank you Suresh. Have a great day.

[Chanty4u]

hi jagan,& Qlikview wizard,

one more clarification on above issue..

i select nul value and lessdan 1k   ....i am nt finding any variation on bubbles...can u please explain on that

and one more..after including the above expresion it chngeing the colour also ...bt i want to display same colur wen i select clear all

Thank you...

[Chanty4u]

sry dat is nt null value..

[jagan]

Hi Suresh,

The IPGK value for Null value is Null that is why you are getting different color and all bubbles are of same size, filter Null value in IPGK range column in script.

Also I think there is no need of Mode dimension in the chart.

Hope this helps you.

Regards,

Jagan.

[jagan]

If IPGK value is not null then make it as 0 like below in script

LOAD

If(IPGK = '-', 0, IPGK) AS IPGK,

'

'

FROM DataSource;

Hope this helps you.

Regards,

Jagan.