Highlighting particular week or range of time in stack bar chart or 2 dimension line chart

[mayankraoka]

Hi Team,

I have a requirement to highlight particular week in stack bar chart.On x-axis dimension is week and y-axis is sum of sales and 2nd dimension is products.I want to highlight say z week as it is important for analysis.I know highlight it by different color but want to have some different way.

Another similar requirement is in for line chart.Is there any way to highlight/show particular week data marker different way?

Please let me know in case you need any other info.

Regards,

Mayank

[mayankraoka]

Any help on this please?

[marcus_sommer]

I think a small example and a picture how the result should look like would be useful.

- Marcus

[anagharao]

Hi,

is this what you are looking for?

[mayankraoka]

Hi Marcus,

Please find both the chart images in both the attached chart ,I want 24-07-2015 week should be highlighted in different way from rest weeks.

Please check this and let me know in case you need any other info.

Regards,

Mayank

[marcus_sommer]

You could highlight a particular column with an attribute-expression. Press in tab expression on the small + sign by the expression and choose background-color. As expression could you use a simple if-loop like:

if(Date = '24-07-2015', red())

whereby in this simple form it will color the complete bar in red (and also the legend). But you could do it a bit more sophisticated with:

if(Date = '24-07-2015' = 2, ColorMix1(1, red(), color(rowno())))

which will use the colors of the color-palette form your object (tab colors) and change them to a more brighter color with one of the various qlikview color-functions. For those have a lop within the help and play a bit with them to get a sufficient result.

This will also effect the coloring from the legend as a side-effect which AFAIK couldn't be adjusted. If the legend is important you could create an outside legend.

- Marcus

[mayankraoka]

Thank you Marcus.

I am getting error in colormix expression.

Can you please give me the expression for that.

if([Week Ending Dt] = '24-07-2015' = 2, ColorMix1(1, red(), color(rowno())))

[marcus_sommer]

Oh sorry, there is a small copy-error from my testing on month, please remove the bolded part:

if([Week Ending Dt] = '24-07-2015' = 2, ColorMix1(1, red(), color(rowno())))

- Marcus

[mayankraoka]

Hi Marcus,

Please find both the images after change.Stack bar chart remains same.

Regards,

Mayank

[marcus_sommer]

In my testing it worked:

therefore please provide an small example.

- Marcus