Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
dnorton2
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

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

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)
dnorton2
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

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

dnorton2
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

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)