topic Re: Setting a conditional format on a Full Accumulation chart in QlikView

Setting a conditional format on a Full Accumulation chart

Thu, 21 Jul 2016 07:07:18 GMT

Hi I have created a series of charts the first shows simply the average of a dataset, the second shows the distribution of the dataset and the third using the Full Accumulation button shows the cumulative distribution

I would like to set up a conditional format whereby the columns in the last chart change colour when they reach say 90% of the total

Is this possible and can I do it without complicated scripting !!

Re: Setting a conditional format on a Full Accumulation chart

Thu, 21 Jul 2016 07:46:43 GMT

‌do this in the background colour of the expression

if ( avg(sales)/avg( total sales ) >=.9,

Rgb(0,255,0))

Re: Setting a conditional format on a Full Accumulation chart

sunny_talwar — Thu, 21 Jul 2016 10:08:37 GMT

What is the expression you are using for accumulation here? Are you using the QlikView's inbuilt accumulation or are you using RangeSum(Above())?

Re: Setting a conditional format on a Full Accumulation chart

Thu, 21 Jul 2016 21:49:15 GMT

In the bottom chart I am not using an expression rather I am just using the Full Accumulation functionality to create the visualization. I am thinking I probably need to use an expression which I can then do the arithmetic off for the conditional format I am just not sure what it is. Will look closer at both pieces of feedback now - Thanks Both

Re: Setting a conditional format on a Full Accumulation chart

Thu, 21 Jul 2016 23:29:28 GMT

OK Sunny so I have changed my chart away from using Full Accumulation to instead use this expression

RangeSum(Above(NumericCount ([Release Time]),0,RowNo()))

Which gives me the accumulation I am looking for but I am still struggling to do the % part despite reading many of your helpful posts

So I have release time as a dimension and from the accumulation I know that for the longest release time the Numeric Count of events is 29. I would now wish to identify the first release time whose cumulative events is greater than 90%

Hope that makes sense

Thanks

Jason

Re: Setting a conditional format on a Full Accumulation chart

Fri, 22 Jul 2016 00:26:35 GMT

Sorry Sunny - Took a break and it became clear

I used

if(RangeSum(Above(NumericCount ([Release Time]),0,RowNo()))/NumericCount(total([Release Time]))>0.9,red(),blue())

Re: Setting a conditional format on a Full Accumulation chart

sunny_talwar — Fri, 22 Jul 2016 10:18:58 GMT

So its all working now? If it is, I would suggest closing this thread by marking your own answer as a correct one.

Best,

Sunny