Background colour not showing correct colour for Target

helen_pip — Thu, 23 Feb 2017 21:18:01 GMT

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

Re: Background colour not showing correct colour for Target

settu_periasamy — Fri, 24 Feb 2017 06:09:11 GMT

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.

topic Re: Background colour not showing correct colour for Target in QlikView

Background colour not showing correct colour for Target

Re: Background colour not showing correct colour for Target