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

[#1]

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.

Thanks,

Sanal

[sunny_talwar]

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

[#3]

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

[rwunderlich]

Take a look at this similar example:

Qlikview Cookbook: Outliers http://qlikviewcookbook.com/recipes/download-info/outliers/

-Rob

http://masterssummit.com

http://qlikviewcookbook.com