topic Re: Set Analysis - Ignore Selection in QlikView

Set Analysis - Ignore Selection

Anonymous — Thu, 13 Aug 2015 09:02:48 GMT

Hello,

In the example attached, the current expression is, for 2016 data:

=count({<Financial_Month={'<= $(=Financial_Month)'},Financial_Year={2016}>}Service)

This shows Financial_Month 1 to 6 if Month 6 is selected, but I want the line chart at the top to ignore the value selected in the Financial_Month listbox, but allow other selections (such as Type) to be filtered. I suspect the answer is obvious, but I cannot find it!

Thanks,

Paul

Re: Set Analysis - Ignore Selection

sunny_talwar — Thu, 13 Aug 2015 09:04:31 GMT

May be this is what you want:

=Count({<Financial_Month=, Financial_Year={2016}>}Service)

Re: Set Analysis - Ignore Selection

MK_QSL — Thu, 13 Aug 2015 09:08:13 GMT

As replied by Sunny, to ignore any selection you need to add

FieldName =

in set analysis

SUM({<Month =, Year = >}Sales)

In above example, Total Sales will ignore selections made in Month and Year Field/ListBox.

Re: Set Analysis - Ignore Selection

awhitfield — Thu, 13 Aug 2015 09:09:34 GMT

Hi Paul,

you need to remove the part:

{'<= $(=Financial_Month)'}

from all three expressions, e.g.

=count({$<Financial_Month=,Financial_Year={2014}>}Service)

=count({$<Financial_Month=,Financial_Year={2015}>}Service)

=count({$<Financial_Month=,Financial_Year={2016}>}Service)

HTH - ANDY

Re: Set Analysis - Ignore Selection

Anonymous — Thu, 13 Aug 2015 09:17:10 GMT

Thanks all.

Re: Set Analysis - Ignore Selection

daniel_kusiak — Thu, 13 Aug 2015 09:31:25 GMT

If it comes to set analysis i find this tool useful - http://tools.qlikblog.at/SetAnalysisWizard/QlikView-SetAnalysis_Wizard_and_Generator.aspx?sa=