topic Re: SVG map chart issue. in QlikView

SVG map chart issue.

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Please check the .qvw file I attached and the problem that I face with it is that when I click on Year or Quarteror any other filters filters the states in the Map disappear. I just wanna display the number of subcribers for a particular filter value. Can someone please help me out!

Re: SVG map chart issue.

MK9885 — Thu, 15 Dec 2016 13:41:17 GMT

Your Data model has way too many Synthetic keys.

Clean up the data model or provide us with your data...?

State, Region, Year, Quarter, Month, Mobility and Customer Segmentation are repeating fields in all tables.

Every other thing looks fine. I've tested with my own SVG path.

You can probably use only 2 Tables? Use one Primary key.

Re: SVG map chart issue.

Fri, 16 Dec 2016 03:56:23 GMT

These are the data that I use.

Re: SVG map chart issue.

Anil_Babu_Samineni — Fri, 16 Dec 2016 05:01:32 GMT

How is your color expression seems and Can you send Data model by using Ctrl + T and then share with us.

Re: SVG map chart issue.

Fri, 16 Dec 2016 05:07:53 GMT

Here is my data model.

Re: SVG map chart issue.

Anil_Babu_Samineni — Fri, 16 Dec 2016 05:13:00 GMT

You have lot synthetic keys, That is not a problem to show SVG any how, Can you send Expression over there which you used to form the SVG? If so, might i have to llok. And then you have to send screen shot of Properies which is showing the tab for SVG Map

Re: SVG map chart issue.

Fri, 16 Dec 2016 05:18:34 GMT

=if(Sum (No.of.Subscribers)>147120,'#336633',if((Sum (No.of.Subscribers)<147102 AND Sum (No.of.Subscribers)>146902),'#5b845b',if((Sum (No.of.Subscribers)<145673 AND Sum(No.of.Subscribers)>145473),'#d87f7f',if((Sum (No.of.Subscribers)<145553 AND Sum(No.of.Subscribers)>145273),'#b20000'))))

Re: SVG map chart issue.

Anil_Babu_Samineni — Fri, 16 Dec 2016 05:30:21 GMT

Try this expression

I hope Hex color codes are won't work. you may use this instead of that

=if(Sum(No.of.Subscribers)>147120,rgb(51,102,51),if((Sum (No.of.Subscribers)<147102 AND Sum (No.of.Subscribers)>146902),rgb(91,132,91),if((Sum (No.of.Subscribers)<145673 AND Sum(No.of.Subscribers)>145473),rgb(216,127,127),if((Sum (No.of.Subscribers)<145553 AND Sum(No.of.Subscribers)>145273),rgb(178,0,0)))))

And then use, Map as Plane which is default and then use Path like UsName2.states {Make sure, Qlikview is Case Sensitive - Be check whether Fields are correct or not and then check if there is any reaction or open anything then let us know}

Re: SVG map chart issue.

Fri, 16 Dec 2016 05:41:15 GMT

There was no change after using that expression you gave me. Then I cant use this path UsName2.States because I dont have that chart in my svgmap folder, UsName2 is saved as a svg file in the svgmap folder. I dont understand "Map as Plane" what do you mean by that?

Re: SVG map chart issue.

Anil_Babu_Samineni — Fri, 16 Dec 2016 07:08:52 GMT

I am not sure, Where were you due to i don't have license

Try one more time with this, I just removed extra Parenthesis '(' for all if conditions and then i add nor white color

=if(Sum(No.of.Subscribers)>147120,rgb(51,102,51),

if(Sum (No.of.Subscribers)<147102 AND Sum (No.of.Subscribers)>146902),rgb(91,132,91),

if(Sum (No.of.Subscribers)<145673 AND Sum(No.of.Subscribers)>145473),rgb(216,127,127),

if((Sum (No.of.Subscribers)<145553 AND Sum(No.of.Subscribers)>145273),rgb(178,0,0), White()))))

And then use Select or Load a Map (This is for Plane which you are not understand)

Re: SVG map chart issue.

Fri, 16 Dec 2016 08:38:01 GMT

I got the issue cleared. There was no problem with the map but the issue was with the expression. When I click some filter, the value of No.of.Subcribers becomes lesser than 145273 and that is why none of the states gets selected.

I solved the issue by using two variables.

by having Sum(No.of.Subscribers) as variable1

and Sum({<Month = ,[Customer Segmentation]=,Mobility=,Quarter=,State=,[Tariff Plan]=>} No.of.Subscribers) as variable2.

Then I changed the expression in svg map as =if($(Variable1)>=(0.9*$(Variable2)),'#0f3d0f',if((($(Variable1)<(0.9*$(Variable2))) And ($(Variable1)>=(0.7*$(Variable2)))),'#577757',if((($(Variable1)<(0.7*$(Variable2))) And ($(Variable1)>=(0.5*$(Variable2)))),'#9fb19f',if((($(Variable1)<(0.5*$(Variable2))) And ($(Variable1)>=(0.3*$(Variable2)))),'#ffb2b2',if((($(Variable1)<(0.3*$(Variable2))) And ($(Variable1)>=(0.1*$(Variable2)))),'#ff4c4c',if($(Variable1)<(0.1*$(Variable2)),'#ff0000'))))))

Re: SVG map chart issue.

Anil_Babu_Samineni — Fri, 16 Dec 2016 09:19:23 GMT

That's great. I would recommend to use only RGB code not the Hex codes

Re: SVG map chart issue.

Fri, 16 Dec 2016 09:25:04 GMT

SVG map chart issue.

thanks for the clearity in SVG map