topic Re: Percentage issue in bar chart after filter selection in QlikView

Percentage issue in bar chart after filter selection

ashokpaladugula — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

With out selection filters, the percentage calculation is showing as expected. but if i select filter as 2 hrs the calculation showing 100%.

For instance,

Before selection of filter 2 hrs.

Jan month shipments percentage is 23.3 %.

After selection filter 2 hrs,

Jan month shipments percentage is 100%.

Here my requirement is after selection of filter delhours as 2 hrs need to show 23.3 %.

swuehl‌stalwar1‌hic‌

Re: Percentage issue in bar chart after filter selection

krishnacbe — Wed, 08 Feb 2017 18:54:00 GMT

Hi,

You can exclude the selection of DelHours from your chart expression as below.

Sum({1<DeliveryHours ={"<=2"}>} [Shipment Count] ) / Sum({1}[Shipment Count]) apply the exclusion for all the three expressions

Re: Percentage issue in bar chart after filter selection

ashokpaladugula — Wed, 08 Feb 2017 19:01:20 GMT

hi priya,

Appreciate your quick response. But my issue is when i select 2hrs as a filter then in the chart there should be only 2hrs bar with 23.3%.Remaining bars should not shown in the chart.

Re: Percentage issue in bar chart after filter selection

sunny_talwar — Wed, 08 Feb 2017 19:44:26 GMT

What's a difference between DelHours and DeliveryHours?

Re: Percentage issue in bar chart after filter selection

krishnacbe — Wed, 08 Feb 2017 19:51:54 GMT

Please find the attached. hope it resolves the issue.

1. Added Conditional show for expressions

2. fixed the formula to retain the values

Re: Percentage issue in bar chart after filter selection

swuehl — Wed, 08 Feb 2017 21:08:55 GMT

I think it would maybe be better to unlink the table with your listbox selection field to create a data island.

Re: Percentage issue in bar chart after filter selection

ashokpaladugula — Thu, 09 Feb 2017 11:50:42 GMT

hi priya,

Appreciate your quick response, but its working fine but once it reload data it is not working fine.

Thanks,

ASHOK

Re: Percentage issue in bar chart after filter selection

krishnacbe — Thu, 09 Feb 2017 14:47:18 GMT

What is the issue you are facing after the reload?