topic Re: Visual Cues in Chart based on Chart Row in QlikView

Visual Cues in Chart based on Chart Row

Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I have expressions that count the number of cases in the current period, the number of cases in the previous period, and the number of average cases over all time. I've put these expressions in a chart, and my dimension breaks the chart down by Diagnosis. I want to use visual cues to make a Current Period Cases row turn Green if it is greater than the average. So in my example above, the first row, is 116 current period cases, and the average is 87, so it would turn green.

I tried putting the expression for average cases into the visual cues, but it is comparing current period cases to the TOTAL average cases, not the average case per line in the chart. Does anyone know how to get it to compare it to the average per line?

Thanks!

Melissa

Re: Visual Cues in Chart based on Chart Row

sunny_talwar — Thu, 06 Oct 2016 22:50:56 GMT

May be use background color expression to get different colors.

Colors in charts

Re: Visual Cues in Chart based on Chart Row

Thu, 06 Oct 2016 23:07:00 GMT

No sorry, that doesn't work. It doesn't deem any of the values as true and is coloring them all the false color.

Re: Visual Cues in Chart based on Chart Row

akash3191 — Fri, 07 Oct 2016 05:56:59 GMT

Hi Melissa,

Not necessarily this has to be achieved using the Visual cues. You can also use the background color option that appears under the expression. Below are the steps to do the same.

1. Go to the properties of the table.

2. Expand the expression "Current Period Cases".

3. Select "Background Color" from the list.

4. Enter the expression,

if([Current Period Cases]>=[Average # Cases], Green(), Red())

Hope this helps.

Re: Visual Cues in Chart based on Chart Row

sunny_talwar — Fri, 07 Oct 2016 06:04:49 GMT

Would you be able to share a sample? or at least share the expression you tried?

Re: Visual Cues in Chart based on Chart Row

jyothish8807 — Fri, 07 Oct 2016 06:22:23 GMT

Hi Melissa,

Pfa sample. Hope this is what your looking for .

Regards

Re: Visual Cues in Chart based on Chart Row

Anil_Babu_Samineni — Fri, 07 Oct 2016 07:15:17 GMT

Would you got solution or else try with ColorMax2() function

Re: Visual Cues in Chart based on Chart Row

Mon, 10 Oct 2016 18:50:06 GMT

I went back and tried again and got it to work by adding the Num() around the second portion of the equation. I am not sure why that helped, though.

This worked:

If($(mEDVisitVolumeDateParameter(Date={">=$(=date($(=zFlexibleDateInterval1)))<=$(=date(vAsOfDate))"}))>Num($(mEDVisitVolume)/($(mDaysInPeriod)/$(mDaysInPeriodCompareCurrent)),'##.##'),red(),green())

I previously was trying this and it wasn't working:

If($(mEDVisitVolumeDateParameter(Date={">=$(=date($(=zFlexibleDateInterval1)))<=$(=date(vAsOfDate))"}))>$(mEDVisitVolume)/($(mDaysInPeriod)/$(mDaysInPeriodCompareCurrent)),red(),green())