Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Exclusion of top 1% and bottom 1% from the staright table

Hi All,

Please help me out in this scenario!

Requirement :

The top 1% and bottom 1% data should be excluded from the straight table.

I tried from my side, the exclusion  is happening statically but it is not happening on dynamically(when I select on the list box) the straight table data is not changing accordingly.

I am attaching the excel source file and qvw along with this description.



3 Replies

Would you be able to share information on what is the expected output you are hoping to see? With or without selections?

Not applicable

  • Whenever selection is happening on the list boxes then the exclusion(Top 1% and Bottom 1%) should happen dynamically based on the selected dataset so in straight table only 98% data should show after exclusion.
  • The same exclusion needs to be done for bar graph also.
MVP & Luminary
MVP & Luminary