Set Analysis - Ignore Selection

[Anonymous]

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

[sunny_talwar · Accepted solution]

May be this is what you want:

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

[MK_QSL]

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.

[awhitfield]

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

[Anonymous]

Thanks all.

[daniel_kusiak]

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