Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Read about Qlik’s Response to COVID-19 Read the Letter, Join the Group.
Not applicable

Forced *inclusion* instead of exclusion?

I have an expression for which I can use forced exclusion to ignore/remove certain dimensions. For example:

SUM({$<Product=,Type=>} CallCount)


In that case we can get the CallCount without taking any Product or Type selections into consideration.

However, it is possible that this list of exclusion fields will have additions/deletions/changes in future builds as client data changes. So rather than causing a maintenance headache in which expressions would need to be updated from month-to-month, is there a way instead to create an expression that simply specifies which dimensions to pay attention to, rather than which to ignore?

For example, if I only want my CallCount sum to include considerations from the dimensions "DetailType" and "MonthID", and ignore all others that may be in the table (Product, Type, etc) - is there a way to do this?

Thanks!

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Forced *inclusion* instead of exclusion?

Yes.

SUM({1<Product=$::Product,Type=$::Type>} CallCount)

This expression will ignore ALL selections except Product and Type.

View solution in original post

1 Reply
Highlighted
Partner
Partner

Re: Forced *inclusion* instead of exclusion?

Yes.

SUM({1<Product=$::Product,Type=$::Type>} CallCount)

This expression will ignore ALL selections except Product and Type.

View solution in original post