topic Highlight current selection within straight table chart in QlikView

Highlight current selection within straight table chart

Tue, 22 Nov 2011 10:52:14 GMT

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

Highlight current selection within straight table chart

swuehl — Tue, 22 Nov 2011 11:22:32 GMT

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

Highlight current selection within straight table chart

Tue, 22 Nov 2011 11:27:23 GMT

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

Highlight current selection within straight table chart

swuehl — Tue, 22 Nov 2011 12:01:09 GMT

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

Highlight current selection within straight table chart

Thu, 24 Nov 2011 10:54:00 GMT

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

Highlight current selection within straight table chart

swuehl — Thu, 24 Nov 2011 11:11:51 GMT

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?

Highlight current selection within straight table chart

Thu, 24 Nov 2011 11:15:56 GMT

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

Regards,

Craig

Highlight current selection within straight table chart

udaya_kumar — Wed, 18 Apr 2012 07:20:54 GMT

hi stefan,

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

Highlight current selection within straight table chart

udaya_kumar — Wed, 18 Apr 2012 07:31:56 GMT

Hi stefan,

thanks for the expression,

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

thanks