topic Re: set analysis, if expression, and dimension filters in App Development

set analysis, if expression, and dimension filters

Thu, 25 Aug 2016 19:54:42 GMT

Good Morning (still morning in Hawaii!),

We use Qlik Sense.

I am simplifying this from what we actually did.

Lets say that we had dimensions 1-10. We wanted our budget numbers to display for dimension 1-3 if filtered on and displayed as 'N/A' if dimensions 4-10 are filtered. The problem that arose is that we only budget based on dimension 1-3 and not on dimensions 4-10. When filtering on dimensions 4-10 it was showing a weird budget where there was not one. So we used set analysis on a sum of the budget number to accomplish this:

if(round((Sum({$<dimension4=,dimension5=,dimension6=,dimension7=,dimension8=,dimension9=,dimension10=>}SalesBudget)))=(round(sumSalesBudget))),sum({$<dimension4=,dimension5=,dimension6=,dimension7=,dimension8=,dimension9=,dimension10=>}SalesBudget),'N/A')

It worked perfectly. The problem is the list keeps on building as we add more data, so we still want dimensions 1-3 to display a budget number when filtered on, but now we have dimensions 4-20 that need to display 'N/A'. Is there a way with set analysis to do the inverse of what we are doing?

Any help is appreciated!

Re: set analysis, if expression, and dimension filters

sunny_talwar — Fri, 26 Aug 2016 00:16:26 GMT

You can try the technique specified here:

Ignore all selections except some specific fields using Set Analysis

Re: set analysis, if expression, and dimension filters

Fri, 26 Aug 2016 19:13:07 GMT

Thank you! The technique you referenced had to be tweaked a little bit, but it appears to have done what I needed!

Re: set analysis, if expression, and dimension filters

sunny_talwar — Sat, 27 Aug 2016 13:27:35 GMT

Awesome

Please close this thread by marking the correct answer if you got what you wanted to achieve.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny