topic Re: How Do I Create a Chart Which Is Not Affected By A Specific Filter? in QlikView

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

Tue, 24 Jul 2012 14:31:47 GMT

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

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

Tue, 24 Jul 2012 14:36:06 GMT

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

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

Tue, 24 Jul 2012 14:55:04 GMT

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

Kiran.

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

jagannalla — Tue, 24 Jul 2012 15:05:10 GMT

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=>}

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

Tue, 24 Jul 2012 15:14:33 GMT

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)

)

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

Tue, 24 Jul 2012 15:56:28 GMT

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

Kiran.

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

Tue, 24 Jul 2012 20:26:10 GMT

Perfect!

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

satheshreddy — Mon, 11 Jul 2016 06:53:00 GMT

hi,

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

regards

Sathish