topic Re: Duplicate (but independent fields) as data island in QlikView

Duplicate (but independent fields) as data island

DennisNorton — Tue, 30 May 2017 20:04:06 GMT

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

Re: Duplicate (but independent fields) as data island

Anil_Babu_Samineni — Wed, 31 May 2017 02:18:23 GMT

Like this?

Re: Duplicate (but independent fields) as data island

DennisNorton — Wed, 31 May 2017 14:06:25 GMT

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.

Thanks

Re: Duplicate (but independent fields) as data island

neelamsaroha157 — Wed, 31 May 2017 14:11:07 GMT

Re: Duplicate (but independent fields) as data island

DennisNorton — Wed, 31 May 2017 14:27:33 GMT

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:

After:

Thanks

Re: Duplicate (but independent fields) as data island

neelamsaroha157 — Wed, 31 May 2017 14:37:51 GMT

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.

Re: Duplicate (but independent fields) as data island

Digvijay_Singh — Wed, 31 May 2017 15:08:12 GMT

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

Re: Duplicate (but independent fields) as data island

Anonymous — Wed, 31 May 2017 15:13:05 GMT

that is a really good idea ... !

Re: Duplicate (but independent fields) as data island

DennisNorton — Wed, 31 May 2017 15:36:15 GMT

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)

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?

Re: Duplicate (but independent fields) as data island

Anil_Babu_Samineni — Wed, 31 May 2017 15:58:51 GMT

Sure, May be attached

Re: Duplicate (but independent fields) as data island

DennisNorton — Wed, 31 May 2017 16:40:24 GMT

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.

Re: Duplicate (but independent fields) as data island

neelamsaroha157 — Wed, 31 May 2017 17:36:40 GMT

Check the attached sample.

Re: Duplicate (but independent fields) as data island

Anil_Babu_Samineni — Wed, 31 May 2017 17:36:51 GMT

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)

Re: Duplicate (but independent fields) as data island

neelamsaroha157 — Wed, 31 May 2017 17:37:57 GMT

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