topic Re: Colours in legend for the same dimension values in QlikView

Colours in legend for the same dimension values

Wed, 25 Nov 2020 16:16:04 GMT

Hi All

I have a bar chart in which i'm comparing the current month data, to the previous month data using two expressions

and two dimensions

I have Legend as follows what i want

all the countries should have same colours in comparision with previous month

if one country is green in colour in current month it should be the same colour in previous month

Re: Colours in legend for the same dimension values

Anil_Babu_Samineni — Wed, 26 Oct 2016 16:25:30 GMT

Would you share the application or expressions

Re: Colours in legend for the same dimension values

Wed, 26 Oct 2016 16:48:55 GMT

for current month sum({$<MonthYear={"=$(=max(MonthYear))"}>}Value )

for previous month sum({$<MonthYear={"$(=date(AddMonths(max(MonthYear),-1),'YYYYMM'))"}>}Value )

for pre previous month sum({$<MonthYear={"$(=date(AddMonths(max(MonthYear),-2),'YYYYMM'))"}>}Value )

Top two values in current month comparing the same values with previous month

that is the thread where my application is and its name is 67.qvw

below iss the chart i japan is blue in colour in 2016 06 then it should be blue in colour in the previous month as well

Re: Colours in legend for the same dimension values

rwunderlich — Wed, 26 Oct 2016 17:04:28 GMT

If you have 18 or fewer countries you can add this background color expression to each expression:

=color(FieldIndex('Country', Country))

If you have more than 18 Country values you have to tweak the expression a bit like this:

=color(

RangeMax(

Mod(FieldIndex('Country', Country),18)

,1)

)

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Colours in legend for the same dimension values

Wed, 26 Oct 2016 17:15:49 GMT

Hi Rob

Thank god, i'm a very excited that you replied to me, i regularly follow your posts,

I have been struck in a an issue since the last 1 month

But the expression you provided is not working for me

i'm looking for something like this

fro three different countries three colours and and the same country in the previous month have the same colour as the current month

Re: Colours in legend for the same dimension values

HirisH_V7 — Wed, 26 Oct 2016 20:05:52 GMT

As Rob Mentioned,

use the expression -> Back Ground Expression ->

-Hirish

Re: Colours in legend for the same dimension values

Wed, 26 Oct 2016 20:13:38 GMT

hi can u please atatch the sample qvw i tried it but not working

Re: Colours in legend for the same dimension values

Wed, 26 Oct 2016 20:15:56 GMT

i'm getiing a unique colour i want a different colour for differt values

Re: Colours in legend for the same dimension values

HirisH_V7 — Wed, 26 Oct 2016 20:20:36 GMT

Hi,

do u need same color for every country,For every month right!!!

Check this,

PFA

Hirish

Re: Colours in legend for the same dimension values

Wed, 26 Oct 2016 20:24:43 GMT

yes

Re: Colours in legend for the same dimension values

HirisH_V7 — Wed, 26 Oct 2016 20:28:42 GMT

Did u Got u r desire output johncena

Re: Colours in legend for the same dimension values

Wed, 26 Oct 2016 20:30:45 GMT

No harish

Re: Colours in legend for the same dimension values

HirisH_V7 — Wed, 26 Oct 2016 20:45:59 GMT

Can you post your sample app and mention u r requirement??

Re: Colours in legend for the same dimension values

rwunderlich — Wed, 26 Oct 2016 22:30:26 GMT

Hi John,

Hirish's example works for me. My example wouldn't add anything.

Can you post your example qvw to help us understanding why it's not working for you?

BTW, I edited my orginal reply to show how to handle more than 18 (number of colors on the pallete) values.

-Rob

Re: Colours in legend for the same dimension values

Wed, 26 Oct 2016 23:21:21 GMT

Hi Rob its working fine for me Thank you so much

I have created a legend (dummy legend) as below this legend is a chart(with suppressed expressions ) and how can i show the same colours in the below dummy legend for the same countries in the above chart

Re: Colours in legend for the same dimension values

Wed, 26 Oct 2016 23:23:19 GMT

Rob

One of the toughest requirement is, comparing the top n values in current period to the same top n values in the previous period and pre previous period can you please help us in this

The easiest way to achive and the logical way.

Regards

John

Re: Colours in legend for the same dimension values

rwunderlich — Thu, 27 Oct 2016 00:15:47 GMT

John,

You can use the same background color expression in your dummy legend / straight table.

-Rob

Re: Colours in legend for the same dimension values

rwunderlich — Thu, 27 Oct 2016 00:19:45 GMT

Hi John,

As comparing Top n over periods seems like an entirely new question, I suggest you start a new thread on that question. And close this thread (by marking something correct) if the color question is answered.

-Rob

Re: Colours in legend for the same dimension values

Thu, 27 Oct 2016 00:45:00 GMT

Hi Rob can you please find the thread

Comapring Top n values in current month to the same Top nvalues in previous month