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

13 Replies
dnorton2
Partner - Contributor III
Partner - Contributor III
Author

Perfect, thank you!

As an aside, I was curious if there's a way to have the same coloring functionality, but with Island.Country as the dimension instead of CountryName. There is still dependency between the two if I make a selection within the bottom chart, since it uses the original CountryName field.

neelamsaroha157
Specialist II
Specialist II

Check the attached sample.

Anil_Babu_Samineni

May be use this in script in end of the script?

Left Join(Island)

LOAD * Inline [

Island.Country, R, G, B

France, 244, 66, 66

Mexico, 66, 244, 98

USA, 66, 134, 244

];

And use BG Color expression like RGB(R,G,B)

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)
neelamsaroha157
Specialist II
Specialist II

Even after the background color expression you need to check 'Persistent Color'.