Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
ashokpaladugula
Contributor III
Contributor III

Percentage issue in bar chart after filter selection

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 %.

before.png

After selection filter 2 hrs,

Jan month shipments percentage is 100%.

After.png

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

swuehlstalwar1hic

1 Solution

Accepted Solutions
krishnacbe
Partner - Specialist III
Partner - Specialist III

Please find the attached. hope it resolves the issue.

1. Added Conditional show for expressions

2. fixed the formula to retain the values

View solution in original post

7 Replies
krishnacbe
Partner - Specialist III
Partner - Specialist III

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

ashokpaladugula
Contributor III
Contributor III
Author

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.

sunny_talwar

What's a difference between DelHours and DeliveryHours?

krishnacbe
Partner - Specialist III
Partner - Specialist III

Please find the attached. hope it resolves the issue.

1. Added Conditional show for expressions

2. fixed the formula to retain the values

swuehl
MVP
MVP

2017-02-08 22_08_35-.pngI think it would maybe be better to unlink the table with your listbox selection field to create a data island.

ashokpaladugula
Contributor III
Contributor III
Author

hi priya,

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

Thanks,

ASHOK

krishnacbe
Partner - Specialist III
Partner - Specialist III

What is the issue you are facing after the reload?