How Do I Create a Chart Which Is Not Affected By A Specific Filter?

[#1]

This should be easy, but i'm stuck.

I have a chart.  I have 2 filters.

Filter 1 should affect the chart.

Filter 2 should not affect the chart (i.e. the chart is static, no matter what the user selects in filter 2).

What tweak do i need to make in the expression to render filter 2 obsolete (as detaching the chart ignores both filters, not just filter 2)?

Thanks!

Pat

[#2]

In your expression use set analysis sum({1}field)

[#3]

Add set analysis construct use {<field2=>}. This will ignore all selections on field2 (whichever field effects filter 2).

Kiran.

[jagannalla]

If your chart don't want to effect by any filter you need use in expression as Sum({1}Column). If you want to apply for single filter column you need to use in expr  Sum({<FilterColumn=>}Column). for multiple {<FilterColumn1=,FilterColumn2=>}

[#5]

Here is what i have (which is returning null).

What is the correct syntax for the term_type line please?

Thanks!

= AVG(

            aggr(

                     Count ({$<

                     STATUS = {"Active","LOA"},

                     TERM_TYPE = {}

                     >} DISTINCT EEID )

          , CYCM)

)

[#6 · Accepted solution]

=AVG(aggr(Count ({$<STATUS = {"Active","LOA"},TERM_TYPE = >} DISTINCT EEID), CYCM))

Kiran.

[#7]

Perfect!

[satheshreddy]

hi,

in qlik view 11.20 have alternate states is this possible to solve this requirement right

regards

Sathish