Hello,
I was wondering if I could get some help with QlikView please.
I would like to apply conditional color to a pivot table using the following criteria: Highlight "Projected close date" field yellow if the current date ("now" function) subtract 1 (current date not included) and subtracted from the dates within the field is less than ten days. So basically if there are 10 days remaining between the current date and the list of dates in the projected close date field. There is also one more criteria, it should be equal to 25 under the probability field in the table.
The second criteria is highlight orange if the present day (now) subtract 1 (current date is not included) subtracted from the projected close dates field is less than 10 and equal to 50 in the probability field.
Summary
Next 10 days = 50% (now subtract 1 subtract projected close date Is equal to 10 and 25% probability)
Next 10 days = 25% (now subtract 1 subtract projected close date Is equal to 10 and 50% probability)
Past due =<0 days, (now subtract 1 subtract projected close date Is less than 0, % is not relevant)
Sample
| Sales member | Projected close date | Probability |
|---|
| Sales1 | 10/30/17 | 25 |
| Sales2 | 11/05/17 | 25 |
| Sales3 | 10/28 | 50 |
Desired result
| Sales member | Projected close date | Probability |
|---|
| Sales1 | 10/30/17 | 25 |
| Sales2 | 11/05/17 | 25 |
| Sales3 | 10/28 | 50 |
Finally highlight red id the present day and the number of days to close is 0 or greater.
Unrelated to the above formula one of my dimension fields is displaying 10.00463746 and I would like to know how to format it to just 10 please.
Many thanks,
Esther
