Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Filter for a dynamic field in a pivot table

Hi all!

I have a table titled Outlier Analysis as shown below:

Snap1.jpg

In this table, I'm doing a simple Outlier Analysis for each of the lines. The logic to decide if a Quote price from one supplier is Outlier/OK is: if([Quote Price]>=(1+v_Outlier)*Avg_Quote,'Outlier',

if([Quote Price]<=(1-v_Outlier)*Avg_Quote,'Outlier','OK'))

where [Quote Price] is the price for that line from the supplier and Avg_Quote is the Avg of all the suppliers' Quote Prices, calculated from the script and v_Outlier is a variable which is a user input and can be changed from the slider on the left(after Quotes Scale text box).

 

Now what I want to have here is a filter or a button that should Exclude all the line items which are Outliers and show only the items which show up as 'OK' in the table. I have tried using the same logic in a List box expression but sadly it doesn't work. This has been made complex by the fact that the Outliers are dynamic and change according to the user input on the slider as I can't create a field to use as a filter in the script.

Any help is much appreciated. Attaching the app for your reference.

@sunny_talwar @tresesco 

Thanks in advance.

2 Replies
Highlighted
Digital Support
Digital Support

I would point you to the following Design Blog posts which should put you on the right track:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822

Hopefully those help you move things along.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
Highlighted

I think to do this, you will need a field which is a combination of Baseline # and Supplier created in the script. This field can be as simple as this:

[Baseline #]&'|'&Supplier as [Baseline Supplier Key]