topic Re: Set Analysis Adjustment for the specific product in App Development

Set Analysis Adjustment for the specific product

profilejamesbond — Tue, 07 Oct 2025 07:46:50 GMT

Hi,

I have Sales by Products.

For example:

Product, Sales

A, 1

B, 2

C, 3

I wrote set analysis with Sum of Sales for the Product A

=Sum ({<Product = {A}>} Sales)

Now, set analysis shows me the Sales of Product A when Product A selected or there is no selection for the Product.

Problem is when I select the Product B or C then I don't see anything in the set analysis it shows me -.

Object is to show the Sum of Sales for the Product A whether the Product A selected or not also show me the sales for the Product A even Product B or C selected. I mean I don't want to include Product B or C in any case.

Thanks

Re: Set Analysis Adjustment for the specific product

Vegar — Tue, 07 Oct 2025 07:56:47 GMT

If your data model and expression is as you describe then Sum ({<Product = {A}>} Sales) should be enough, but if you are making selections in any other field then that will effect your measure.

Example:

If you set analysis is done on product_id, but your users filter on Product then the - will appear.

Sum ({<product_id = {A}>} Sales)
User filters on Product=B
The output will be null because a filter on product_id=A and Product=B give no result

If possible change either the set expression or the filter given to the users. Or clear out the user filter in the modifier like this:

Sum ({<Product=, product_id = {A}>} Sales)

Re: Set Analysis Adjustment for the specific product

profilejamesbond — Tue, 07 Oct 2025 08:07:34 GMT

Hi @Vegar,

There is no parent category. Just as simple as it is.

But, how to write an expression where I would like to say just select this product and whatever the selection is inside the same dimension just ignore it.

I tried these modifiers but no luck:

Product = {'A'}, Product =

Product = {'A'}, Product -= {'B', 'C'}

Product = {'A'}, Product = e(Product)

Thanks

Re: Set Analysis Adjustment for the specific product

Vegar — Fri, 10 Oct 2025 21:07:20 GMT

It seems like you are leaving out some details in your explanation.

If you have the data as scripted below

product_sales_data: LOAD * inline [ Product, Sales A, 1 B, 2 C, 3 ];

Then the expression sum({<Product = {'A'}>}Sales) should ignore any selections made to the Product dimension. See screenshot below - I've made a selection to Product = B, but that expression still calculates only for the A product despite the selection.

Re: Set Analysis Adjustment for the specific product

howdash — Mon, 20 Oct 2025 12:17:03 GMT

Have you tried this:

Sum ({<Product -= {‘B’, ‘C’}>} Sales)

This tells Qlik Sense to sum sales for products that are not B or C - in your example, that would be sales for product A only.