Only Show Values that Meet Multiple Conditions from 2 Fields

[ToddE]

Happy Friday

I have a table and I only want it to display a small subset of the masses of data that's available.

The value appears in a field named [Product], but I only want the table to display products that contain the term "professional".  I also want the table to only contain products that are "Active", which is captured in a field named [Status].

I've experimented with the Aggr function, but cannot get the correct results.

Thank you for any help!

[rubenmarin · Accepted solution]

HI, you can add a measure with set analysis to filter data, like:

Sum({<Product={"*professional*"},Status={'Active'}>} Sales)

[vinieme12]

Refer these articles

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344#:~:text=Set%20a....

https://www.analyticsvidhya.com/blog/2014/01/set-analysis-qlikview/

[sidhiq91]

You can resolve the issue in couple of ways:

1. In load editor you can apply the filter in the where condition,

Where wildmatch(Product,'*Professional*') and Status='Active'

2. You can use a Set Analysis, For Example:

Sum({<Product={"*Professional*"}, Status={'Active'}>}LineSalesAmount)