Filtering and Calculated Dimension Based on Weekly Buckets

Anonymous — Wed, 26 Feb 2014 00:29:36 GMT

Hi!

Could someone helped me with my formula? I have a 36 weekly buckets from W1 to W36...

1. I'd like to filter only the material field to show only those which weekly field from Week 1 to W9 has more than 2 values of less than 80% (in Coverage item in Key Figures field)? ... This means if values that has less than 80% from Week1 o 9 will be excluded from the pivotchart. I would prefer to place my expression in the material as I already have an expression in the

2. After the 1st condition met, I need to create a new column "Color Code" to place "Red" if at least 1 below 80% falls from W1 to W6... IF the below 3 below 80% falls from W7-9, then 'Yellow'... I believe this need a complex set analysis formula and really had a hard time composing the formula.

Tks.

P.s. I have attached my sample file for easy understanding.

topic Filtering and Calculated Dimension Based on Weekly Buckets in QlikView

Filtering and Calculated Dimension Based on Weekly Buckets