topic Re: How do I select a field in a chart to highlight my selection without filtering out the other fie in QlikView

How do I select a field in a chart to highlight my selection without filtering out the other fields?

Wed, 06 Jul 2016 21:20:44 GMT

Is there a way to highlight the selected field without drilling or filtering out the rest of the fields in a bar chart? In other words, I'd like all of the fields to stay static in a bar chart but when I select on field A, for example, that gets highlighted but Field B and Field C remains on the chart.

Here, I have my dimension set to =if(Category='A', DimensionA) and my expression set to 1-[Value]

Any help is appreciated!

Re: How do I select a field in a chart to highlight my selection without filtering out the other fields?

sunny_talwar — Wed, 06 Jul 2016 21:38:42 GMT

May be like this as your expression:

1 - Only({<[Field B], [Field C]>} Value)

Re: How do I select a field in a chart to highlight my selection without filtering out the other fields?

Wed, 06 Jul 2016 21:54:39 GMT

Thanks Sunny! That worked. In addition, I figured how to highlight. I placed this script in the background color of my expression to highlight by color the field that was selected if anyone is having the same issue :

=if(match([Value],Only({$}[Value])),
Blue(),
LightGray())

Re: How do I select a field in a chart to highlight my selection without filtering out the other fields?

sunny_talwar — Wed, 06 Jul 2016 22:00:41 GMT

You might be able to further shorten this using this:

=If([Value], Blue(), LightGray())

Re: How do I select a field in a chart to highlight my selection without filtering out the other fields?

Wed, 06 Jul 2016 22:06:11 GMT

That's true! I just realized that doing this affects the other charts in the dashboard. Is there a way to keep the other dashboard fields static as well so that selecting a field in one chart won't affect the other charts?

Re: How do I select a field in a chart to highlight my selection without filtering out the other fields?

sunny_talwar — Thu, 07 Jul 2016 01:11:18 GMT

You can move this chart to an alternate state

http://www.learnqlickview.com/alternate-states-in-qlikview/‌

Introduction to alternate states - The Qlik Fix! The Qlik Fix!

Re: How do I select a field in a chart to highlight my selection without filtering out the other fields?

Thu, 07 Jul 2016 14:49:20 GMT

Thanks Sunny! That does work but I have other charts in sheet 2 that reacts to these bar charts. Meaning any selections I make in my 3 bar charts will reflect pie charts in sheet 2 (or tab 2). How do I proceed with creating 3 alternate states for these bar charts and still have it interact with the pie charts in sheet 2? In the pie charts, I have the calculated dimension for one alternate state as: =$(=only({[AlternateStateA]} Dimension))

This works just fine with one alternate state but I'm not sure how to incorporate the 2 other ones in this calculated dimension. I really appreciate your help!!

Re: How do I select a field in a chart to highlight my selection without filtering out the other fields?

sunny_talwar — Thu, 07 Jul 2016 14:57:01 GMT

I think you need to provide a sample to help us understand what you have and what you need. It is difficult to imagine and provide response. Can you provide a sample of what you have?

Re: How do I select a field in a chart to highlight my selection without filtering out the other fields?

Fri, 08 Jul 2016 00:06:31 GMT

Unfortunately, the data cannot be shared. Thanks though Sunny! I'm going to see if someone on site can help me with this and get back to you!

Re: How do I select a field in a chart to highlight my selection without filtering out the other fields?

sunny_talwar — Fri, 08 Jul 2016 13:17:24 GMT

If confidentiality is the concern here, you can check here:

Preparing examples for Upload - Reduction and Data Scrambling

Re: How do I select a field in a chart to highlight my selection without filtering out the other fie

Samrithi — Wed, 02 Oct 2019 17:00:54 GMT

Hi,

I need the same solution. but my expression is 'sum(Value)' and I have used 2 dimensions in the line chart.

one is 'day name' and other is 'weekend' and I weekend also has drill on 'date' .

Its tricky to add for multiple dimensions with only expression.

Appreciate any help.

Thanks,