I am working on this Qlikview application where I need to set background colours for cells in a table based on the value in it. So far soo good.
But, this needs to be done on a hierarchy group, where each value in each group has it's own goal value.
The Main group has five possible values. Each of those values have 3-5 subgroups. I have goal values for each value in the main group, and also for each value in the subgroups.
The group look something like this (except that there are five possible valus in the main group), but they are presented in a drilldown table in QW.
| Main Group | Subgroup | Goal value |
|---|
| Process 1 | | 5% |
| Value 1 | 0.5% |
| Value 2 | 1% |
| Value 3 | 0.5% |
| Value 4 | 3% |
| Process 2 | | 65% |
| Value 1 | 50% |
| Value 2 | 5% |
| Value 3 | 3% |
| Value 4 | 2% |
