topic Block chart Colour Query in QlikView

Block chart Colour Query

Tue, 31 May 2011 09:02:03 GMT

Hi Guys

I have 2 Block charts, one detailing the Number of different Queries and One detailing the Time it took to complete each of the queries.

My issue is I wish that each item retains its colour value in between each chart, as they are both fed from the same file and I literally just built the first then Cloned it and amended expression I thought this would do it but its not,

So in First Chart

Type of Event	Time	Colours
Journals	2,125	Grey
Libor Payment	142	L Blue
Loan Closure	60	L Green
Static amendment	57	Purple
Trade	308	Red

and the second

Type of Event	Number
Journals	12,751	L Blue
Libor Payment	425	L Green
Loan Closure	239	Blue
Static amendment	344	Pink
Trade	308	Yellow

Can anyone advise how I can make this so ?

Thanks

Block chart Colour Query

Tue, 31 May 2011 09:09:04 GMT

Actually I figured the issue, the Time one had an extra result in the list !!! So the number mapping was 1 off, ( Dont know why it had that extra result!!!) But I have amended and mycolours all match !!!

Thanks

Block chart Colour Query

Tue, 31 May 2011 09:11:21 GMT

can u upload the app...

Block chart Colour Query

Tue, 31 May 2011 09:14:54 GMT

Hi Erika

I only have a temp license so cant load it up , but I think I've figured the issue

Thanks

Anne