Box Plot | How to show elements in Box plot based on a criteria

Kaushik2020 — Fri, 11 Nov 2022 08:09:28 GMT

I am using Qlik Enterprise.

I want to ensure box plot is not refreshed/show filtered elements when a user applies filter.
Refresh based on ONLY 2 filter(s), eg: Customer name and Category. Expectation is Box plot should show details based on these 2 filters only. When more filters are applied, it should not filter.

Re: Box Plot | How to show elements in Box plot based on a criteria

Mark_Little — Tue, 22 Nov 2022 07:26:18 GMT

Add 1 to your Set expression to ignore filter and then add back the filters you want something like below

SUM({1<[Customer name],Category>}Amount)