I have an "Amount" field that is comprised of about 20 categories. I want to add a master item that shows the "Amount" for only 3 of those fields instead of all 20. I can do this successfully by adding a filter, but I am trying to create a master item (Dimension or Metric) formula that will do this automatically.
The "Master Item" is part of the Qlik Sense terminology. In QlikView, we don't have "Master Items" - only chart Dimensions and chart Expressions, managed individually in each chart.
If you need to limit the scope of the data that's going to be aggregated, without using selections, - then you need to use Set Analysis. That's the technique of limiting the scope "programmatically" - within an expression, without the need in selecting anything.
It's impossible to explain Set Analysis in a forum post, but you can look it up - in the Help section, in white papers, or in books (including my book QlikView Your Business). You can also learn Set Analysis at a few advanced training venues, including the Masters Summit for Qlik, where I teach Set Analysis and Advanced Aggregation.
cheers,
Oleg Troyansky
Upgrade your Qlik skills at the Masters Summit for Qlik - coming soon to Austin, TX and Johannesburg, South Africa!
Reviewing the Qlik Sense Training Doc I received during the Create Visualization Instructor Led Online Class "Set Modifier" section on Page 147 or the following link
