Change graph based on several expressions

Wed, 05 Oct 2016 09:48:21 GMT

Dear all,

I have the following dataset.

LOAD * INLINE [
CREATED_WEEK, COUNT
40, 12
39, 14
38, 16
];

I have now created a bar graph with the dimension "CREATED_WEEK" and the following expressions:

=sum({$<[CREATED_WEEK2] = {38}>} [COUNT])

=sum({$<[CREATED_WEEK2] = {39}>} [COUNT])

=sum({$<[CREATED_WEEK2] = {40}>} [COUNT])

It all works fine and gives my the following (see sample attachment). However I have certain issues:

- I don't like the colours. Is there a way to change the colours for the different expressions? I tried to change the background colour but couldn't find the option to change the colour. Preferably I would like to highlight the current week and make the others grey.

- My x-labels are not aligned with the graph. Is there a way to easily align them?

Cheers,

Marc

Re: Change graph based on several expressions

sunny_talwar — Wed, 05 Oct 2016 09:54:01 GMT

Is this the goal?

Dimension:

CREATED_WEEK

Expression:

=Sum([COUNT])

Background Color Expression:

=If(CREATED_WEEK = Max(TOTAL CREATED_WEEK), RGB(187,237,0), LightGray())

Re: Change graph based on several expressions

Wed, 05 Oct 2016 10:50:18 GMT

Jes, thanks Sunny!

topic Re: Change graph based on several expressions in QlikView

Change graph based on several expressions

Re: Change graph based on several expressions

Re: Change graph based on several expressions