Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
DennisNorton
Partner - Contributor III
Partner - Contributor III

Duplicate (but independent fields) as data island

I am having trouble with this comparison scenario using a data island, and properly colorizing a bar chart by dimension values.

Graph 1 - Sum(sales)

Graph 2 - Sum({<CountryName = p(Island.Country)>} Sales)

A selection made on CountryName should not affect the values of graph 2, and I think I have that operating correctly. The problem is when I am coloring by dimension and make a selection on CountryName. Graph 2 colors drop off, but the numbers and dimension values remain. Am I using the wrong dimension or possibly the incorrect background color formula?

Thanks

1 Solution

Accepted Solutions
Anil_Babu_Samineni

Sure, May be attached

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

13 Replies
Anil_Babu_Samineni

Like this?

Capture.PNG

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
DennisNorton
Partner - Contributor III
Partner - Contributor III
Author

Anil,

Yes, very close. But what if I want to keep those colors persistent so that France is always red, Mexico always green, USA always blue, regardless of information brought in/out?

For instance, these screens would be incorrect. I am trying to achieve a color based on dimension value, not on order.

image.PNG

image2.PNG

Thanks

neelamsaroha157
Specialist II
Specialist II

Capture.PNG

DennisNorton
Partner - Contributor III
Partner - Contributor III
Author

Neelam,

Thanks, but this will keep colors persistent based on the load order, I believe. If I load India as another country, for example, this throws the colors off. In this example, I want France to remain green, Mexico to remain blue, and Germany yellow from the Before to After.

Before:

Persistent.PNG

After:

NewValue.PNG

Thanks

neelamsaroha157
Specialist II
Specialist II

Other option could be adding Background color if your values are limited, but then it would become hard coded and every time there is new country added to data, you need to add that manually.

If values are fixed then only it will make sense.

Capture.PNG

Digvijay_Singh

You may like to store color code along with countries in the script so they are always attached.

Anonymous
Not applicable

that is a really good idea ... !

DennisNorton
Partner - Contributor III
Partner - Contributor III
Author

Neelam,

I don't mind them being hard coded, and the values are limited, but they can fluctuate between 2 or 5 values loaded in different orders.

Here's the bottom line - I want the top selections to be independent from the bottom and specifically, persistently color-coded.

Here is the BG color formula I use to hard code colors to my countries. The problem is when I select Country Name from the top filter, I don't want this to affect the coloring of the bottom graph (2nd screenshot)

Properties.PNG

This selection scenario would work if the colors for Mexico and USA remained blue and green respectively, but they revert to the false condition. The # values remain, but why doesn't the coloring as well?

Properties2.PNG

Anil_Babu_Samineni

Sure, May be attached

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)