topic Re: Highlighting particular week or range of time in stack bar chart or 2 dimension line chart in QlikView

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

mayankraoka — Wed, 11 May 2016 19:05:42 GMT

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

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

mayankraoka — Thu, 12 May 2016 09:37:06 GMT

Any help on this please?

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

marcus_sommer — Thu, 12 May 2016 10:05:13 GMT

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

- Marcus

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

anagharao — Thu, 12 May 2016 10:22:30 GMT

Hi,

is this what you are looking for?

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

mayankraoka — Thu, 12 May 2016 10:28:34 GMT

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

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

marcus_sommer — Thu, 12 May 2016 10:56:36 GMT

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

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

mayankraoka — Thu, 12 May 2016 11:12:03 GMT

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())))

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

marcus_sommer — Thu, 12 May 2016 11:14:48 GMT

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

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

mayankraoka — Thu, 12 May 2016 11:22:22 GMT

Hi Marcus,

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

Regards,

Mayank

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

marcus_sommer — Thu, 12 May 2016 11:29:47 GMT

In my testing it worked:

therefore please provide an small example.

- Marcus

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

mayankraoka — Thu, 12 May 2016 11:51:32 GMT

For stack bar this will be very confusing for users.Can we increase or decrease the width of that particular bar or show horizontal line for that week to showcase this is our imp week?/

Regards,

Mayank

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

marcus_sommer — Thu, 12 May 2016 12:26:16 GMT

I think this won't be possible. An alternative would be to use two bar-chart which lay over eachother and the lower one is colored on the selected bar the background from the upper one is set to transparency - you might need adjust some of the chart-properties (mostly with transparency instead of hiding because this will lead to changes of the size and position of various chart-parts). If you then changed the distance of the bars within the tab presentation it will look like highlighted (if you are playing with the scale and/or add some amount to your expression the bar could be even higher):

- Marcus

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

mayankraoka — Thu, 12 May 2016 17:25:31 GMT

Hi Anagha,

Your attached app is blank can you send it again.

Regards,

mayank

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

anagharao — Fri, 13 May 2016 02:01:47 GMT

Hi Mayank,

Sorry about that. Correct App attached now.

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

mayankraoka — Fri, 13 May 2016 05:55:39 GMT

Thank you Marcus for all your efforts..

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

mayankraoka — Fri, 13 May 2016 05:56:23 GMT

Hi Anagha,

Can you please share the app again/

Regards,

Mayank

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

anagharao — Thu, 19 May 2016 05:10:47 GMT

Hi Mayank, Did the above app work for you?