Highlight current selection within straight table chart

[#1]

Hi everyone,

I have a static straight table chart which (a) ignores the current selections but (b) highlights the row in the table which matches the Current Selection. This works fine when only a single item is selected but I need this to be able to work for multiple selections for the dimension.

For example:

- A user selects "Joe Smith" as the EmployeeName

- The straight table chart shows all records regardless of the selected EmployeeName

- The row where EmployeeName = "Joe Smith" is highlighted in the straight table chart by setting text format based on GetFieldSelections(EmployeeName)

I need to be able to do the following:

- A user selects multiple values "Joe Smith", "Beth Green" and "Bob White" of EmployeeName

- The straight table chart shows all records regardless of the selected EmployeeName

- ALL rows where EmployeeName = any of the selected values need to be highlighted.

I would appreciate some help on how I can achieve this.

Thanks in advance

Craig

[swuehl]

Instead of using something like EmployeeName = 'Joe Smith' (which is assumingly the result of a condition like EmployeeName = GetFieldSelections(EmployeeName), try a wildmatch:

=if( Wildmatch( GetFieldSelections(EmployeeName), '*'&EmployeeName&'*'), yellow() )

Hope this helps,

Stefan

[#3]

Thanks swuehl.

I tried that syntax but it highlights all records regardless of which EmployeeNames are selected.

I use the current statement to highlight a record in bold but this only works if a single Employee is selected:

=if(EmployeeName = (GetFieldSelections(EmployeeName)),'<B>')

Regards,

Craig

[swuehl]

Just tried it and to my surprise, all dimension values were highlighted, as you said.

I got it working like this (on QV10SR2):

=if(wildmatch(GetFieldSelections([EmployeeName]),'*'&only({1} [EmployeeName])&'*' ),'<b>')

Note that if you select more than 6 values at a time, you might need to increase the maxvalues shown separately in GetFieldSelections passing the max value as third parameter.

Hope this helps and works out,

Stefan

[#5]

Thanks and apologies for the delayed response...due to internet connectivity issues.

I tried your updated code and set the maxvalue to (a) the number of selected items with the GetSelectedCount and also (b) manually to a value of 10 but there seems to be some internal limit around more than 6 values.

I would appreciate it if you had any other suggestions otherwise I will set display calculation to 6 or less in order to work around this limit.

Regards,

Craig

[swuehl · Accepted solution]

At my place, increasing the maxnumber of GetFieldSelection worked just fine:

=if(wildmatch(GetFieldSelections([EmployeeName],',',100),'*'&only({1} [EmployeeName])&'*' ),'<b>')

On what QV version are you?

[#7]

Thanks and that worked perfectly. School boy error on my part as I put the maxvalue in the wrong place!!

Regards,

Craig

[udaya_kumar]

hi stefan,

where i need to put that expression to highlight the row?

[udaya_kumar]

Hi stefan,

thanks for the expression,

i tried it by using it in background color for my requirement, so its working fine

thanks