topic Re: RE:Range in QlikView

RE:Range

Chanty4u — Tue, 18 Aug 2015 07:52:35 GMT

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

Re: RE:Range

sundarakumar — Tue, 18 Aug 2015 08:08:40 GMT

Please add a sample app. are you having issue with a map extension or a scatter chart?

-Sundar

Re: RE:Range

Chanty4u — Tue, 18 Aug 2015 08:31:23 GMT

hi kumar,

its map only..

Re: RE:Range

Chanty4u — Tue, 18 Aug 2015 08:35:46 GMT

hi,,

Please look into app.

Re: RE:Range

sundarakumar — Tue, 18 Aug 2015 09:24:35 GMT

if you want the bullble size to change acordingly use the expression as the third expression.

Hope this helps.

-Sundar

Re: RE:Range

mohammadkhatimi — Tue, 18 Aug 2015 09:57:31 GMT

Hie..

PFA..

Hope this will helps you...!!!

Regards,

Mohammad

Re: RE:Range

jagan — Tue, 18 Aug 2015 10:22:05 GMT

Hi,

Add Sum(IPGK) as third expression in the chart, this will change the bubble size based on the values.

Regards,

Jagan.

Re: RE:Range

qlikviewwizard — Tue, 18 Aug 2015 14:06:41 GMT

Hi Suri,

Did you able to resolve the issue?

Re: RE:Range

qlikviewwizard — Wed, 19 Aug 2015 01:35:39 GMT

Hi Please check this.

Hope this will help you. Thank you.

Re: RE:Range

Chanty4u — Wed, 19 Aug 2015 02:39:11 GMT

Tanq all.

but am nt getting exact ..bcz

wen user select multi values it is shwng same buble size ...its nt appearing wit differnt sizes and wen i select null value it the size of bubble sud be strng wit little big size.

Re: RE:Range

qlikviewwizard — Wed, 19 Aug 2015 02:59:41 GMT

Hi Suresh,

Really I did not understand your issue.

Please elaborate?

Re: RE:Range

Chanty4u — Wed, 19 Aug 2015 03:03:33 GMT

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

Re: RE:Range

jagan — Wed, 19 Aug 2015 03:08:35 GMT

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.

Re: RE:Range

qlikviewwizard — Wed, 19 Aug 2015 03:17:08 GMT

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.

Re: RE:Range

Chanty4u — Wed, 19 Aug 2015 03:18:05 GMT

Tanq jagan and qlikviewwizard)

Re: RE:Range

qlikviewwizard — Wed, 19 Aug 2015 03:20:01 GMT

Hi Suresh,

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

Re: RE:Range

Chanty4u — Thu, 20 Aug 2015 09:02:30 GMT

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...

Re: RE:Range

Chanty4u — Thu, 20 Aug 2015 09:20:58 GMT

sry dat is nt null value..

Re: RE:Range

jagan — Thu, 20 Aug 2015 10:42:40 GMT

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.

Re: RE:Range

jagan — Thu, 20 Aug 2015 10:43:59 GMT

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.