topic Re: Change colour in a chart in QlikView

Change colour in a chart

Anonymous — Fri, 17 Aug 2012 19:04:37 GMT

Hi,

I have Bookmark aaa, where I select Client cc.

I want to see different color for it in a chart.

Or how can I see different color just for 1 client?

I attached a simple file as an example.

Thanks,

Re: Change colour in a chart

Anonymous — Fri, 17 Aug 2012 19:08:30 GMT

in the 1st expression for the background color chenge the expression to

=if (getselectedfiedl(client)='aa', rgb(255,255,0), rgb(255,0,0))

Re: Change colour in a chart

Anonymous — Fri, 17 Aug 2012 19:23:27 GMT

yes, but client is changed dynamically.

Re: Change colour in a chart

Anonymous — Fri, 17 Aug 2012 19:33:24 GMT

try this

=if (getselectedfiedl(client)='aa', rgb(255,255,0),

getselectedfiedl(client)='bb', color2

getselectedfiedl(client)='cc', color3)))

Re: Change colour in a chart

Anonymous — Fri, 17 Aug 2012 19:34:35 GMT

Not in my case. I have thousands clients

Re: Change colour in a chart

Fri, 17 Aug 2012 19:36:26 GMT

Try this for color expression:

=if(GetSelectedCount(Client)>0,

if(match(Client ,concat(distinct Client, ', ')),rgb(255,0,0),rgb(10,100,0))

rgb(10,100,0))

This will highlight the selected clients in red.

It may also make sense to change Result and res to ignore selections in this case:

avg({1}Result)

Sum ( {1}[res])

Re: Change colour in a chart

shree909 — Fri, 17 Aug 2012 19:39:57 GMT

you can create variable vclient= client

and it the expression back ground write if( client ='$(vclient)',rgb(255,255,255),rgb(0,0,0))

something like this. when ever u select a different client then respective colors are shown up.

hope this helps

Re: Change colour in a chart

Nicole-Smith — Fri, 17 Aug 2012 19:40:24 GMT

On your chart, add a background color expression for your first expression:

=if(Client = only({BM01} Client), lightred(), blue())

Your chart should then color whatever is in your bookmark red and everything else should appear blue.

Re: Change colour in a chart

Anonymous — Fri, 17 Aug 2012 19:46:49 GMT

Hi nicole_kowalsky,

Thanks for idea, It works.

How can I manage dynamically bookmark? I want to set up a trigger on leave sheet.

Thanks all you guys,

Re: Change colour in a chart

Nicole-Smith — Fri, 17 Aug 2012 19:48:45 GMT

Can you further explain what you would like your dynamic bookmark to do?

Re: Change colour in a chart

Anonymous — Fri, 17 Aug 2012 19:52:08 GMT

I have some charts on 1-st sheet. I select in Multibox my selection. When I leave this sheet, I want to bookmark my selection. According my selection, show color in the chart.

Thanks,

Re: Change colour in a chart

Nicole-Smith — Fri, 17 Aug 2012 19:59:29 GMT

To change a bookmark upon activating or leaving a sheet, go into the sheet's properties (right click on the sheet, then click Properties). You then need to go to the trigger tab.

Then choose Add Actions > Bookmark. It will give you these three options.

Apply Bookmark will apply selections from a bookmark that is already made.

Create Bookmark will create a totally new bookmark with the selections that are currently made.

Replace Bookmark will replace the selections of an already made bookmark with the current selections.

I hope this is helpful to you!

Re: Change colour in a chart

Anonymous — Fri, 17 Aug 2012 20:02:27 GMT

I did it. Each time Qv adds a new bookmark.

I've never worked with bookmarks. I want to have one bookmark, which changes current selection.

Thanks,

Re: Change colour in a chart

IAMDV — Sat, 18 Aug 2012 16:48:24 GMT

I've made a video on similar topic. You can Load colours from Excel file and give access to users and they change the colours (RGB values). And then we use these colours in Variables instead of hard coding them.

http://qlikshare.com/41

Hope this helps!

Cheers,

www.QlikShare.com

Re: Change colour in a chart

Nicole-Smith — Mon, 20 Aug 2012 11:01:48 GMT

Sounds like you would want to use "Replace Bookmark". This will replace a bookmark specified by "Bookmark Id" with the current selections. This will not create a new one, but will just update an already existing one.

Re: Change colour in a chart

Anonymous — Mon, 20 Aug 2012 13:26:34 GMT

Hi Deepak,

Your idea is good, but in not my case. Client variable is always added.

I need something universal like Bookmark (I didn't have another idea).

Hi Nicole,

I'd like to update update current Bookmark without changes its ID number.

Thanks guys,

Re: Change colour in a chart

Nicole-Smith — Mon, 20 Aug 2012 13:43:04 GMT

If you use Replace Bookmark, the ID number does not change; it just changes what is in the bookmark.

Re: Change colour in a chart

Anonymous — Thu, 23 Aug 2012 17:28:15 GMT

Hi Nicole,

Could you update an expression

=if(Client = only({BM02} Client), rgb(139,191,31), rgb(124,124,124))

BM02 I want to change on variable Var1?

Thank you,