Background colour not showing correct colour for Target

[helen_pip]

Dear Qlikview user

I am attaching a QVW which will hopefully help with my explanation with an ongoing issue I cannot resolve

I want to create a pivot table which will have 2 dimensions

Dimensions

* Month Year

* VUser - A variable which is set to GetFieldSelections($Field) and is added as a drill down group

Expression

My expressions are straight forward Counts and a percentage

Visual Cues

I have an expression on Background colour of the % expression.  My expression is basically stating that if the % is >= Target, then Green() else Red()

However, the visual cue expression works when you click on "Description" from the "View By" button but does not work when I select either "Gender" or "Adult_Paed"

Table 1: Contains an extra dimension "Description".  This table will show the correct colour when you make various selections

Table 2: This is how I would ideally like the pivot table to look, without the extra dimension, but I cannot seem to get the visual cues to show accurately

Could this issue be to how my data is structured. However, if you were to create a table box, you would see how the data is structured

Can anyone offer any advice?

Kind Regards

Helen

[settu_periasamy · Accepted solution]

The problem with the background expression

'if(Target = 'No Target',0,Num#(Target))' in the Table 2

Table 1 is fine, because, you already put 2 dimension

It is showing 4  target values for 'Adult_Paed' and 'Gender' field. (Description would be fine)

The above expression will give the null value, when you select 'Gender' or 'Adult_Paed' option.

see the below screen shot.