Highlighting similar items.

[lawrenceiow]

I'm currently evaluating Qlikview (and products from other companies too) with a view to replacing an existing BI solution. So, I'm trying to replicate an existing dashboard and so far, Qlikview is winning handsdown. However, I have got stuck on a simple issue to do with highlighting rows in a chart table.

First of all I don't want lines to disappear when I select one of them, I have a workaround involving a listbox showing a copy (with a different fieldname so there's no join) of the dimension shown in the chart table. The chart table then changes colour to match the selected item in the listbox : =if(Consultant=GetFieldSelections(Consultant2),RGB(202,40,40),RGB(255,255,255))

However, I would like to highlight, with a different shade, where other items in the chart table belong to the same category as the selected item.

Hopefully the pictures below will help explain things better:

Table 1 shows the Chart Table and table 2 shows a table which has a copy of the dimension used in table 1 along with how the items should be grouped.

When the user selects an item as per table 4 I can change the colour of the matching dimension in table 3 (along with the associated expressions) but I also want to highlight, with a different colour, the other items in table 3 that are in the same group ('Specialty' in this case) as the one selected in table 4.

Any help would be much appreciated.

Lawrence

.

[Nicole-Smith · Accepted solution]

Example is attached (and screen shot is below):

[lawrenceiow]

That looks exactly what I had in mind, the end result anyway, thanks. Also, thanks for taking the time to build a qvw to show me.

I'll have to go away and look up the definitions for 'substringcount' and 'only' and what's going on with that squiggly bracket thingy? Are they angle brackets ('<' and '>') in there or 'greater than' and 'less than' symbols?

Since posting my question I noticed that the source table had Specialty too so I was able to use this formula:

=if(Consultant=GetFieldSelections(Consultant2),RGB(202,40,40),if(Specialty=Specialty2,RGB(223,192,192),RGB(255,255,255)))

[Nicole-Smith]

Anything with the brackets {<>} is set analysis.  You should be able to find information on set analysis, substringcount(), and only() in the QV reference manual.

[lawrenceiow]

Thanks again Nicole. I did try searching Help for only but it came up with 327 matches - substringcount had just the 1 though. I'll go away and read all about Set Analysis as at first glance it looks like what I need to solve another problem I have. If necessary I'll then read the reference manual (though it's mostly the same as the Help screens).

Thanks again for all your help.

Regards

Lawrence

[Nicole-Smith]

Instead of using the search feature in Help, try using the index feature (see screen shot below).  I find it to be much more helpful.

[lawrenceiow]

Of course! I actually used to do that myself but forgot all about it. I've not used Help screens in a long while (before I started with QlikView).

Thanks Nicole.