topic Re: Set Analysis Not Responding to Filters in QlikView

Set Analysis Not Responding to Filters

etrotter — Wed, 25 Nov 2020 16:16:04 GMT

Hello Everyone,

I am trying to create a chart that will not respond to the the time filters, here is what I have so far:

{$<Year=,Month=,WeekNum=>}

It is still responding to the filter selections, any ideas?

Thanks in advance!

Re: Set Analysis Not Responding to Filters

luismadriz — Fri, 17 Nov 2017 04:41:40 GMT

Hi Erica, that's odd! what chart are you working on? Statistic?

Cheers,

Luis

Re: Set Analysis Not Responding to Filters

jonathandienst — Fri, 17 Nov 2017 04:43:57 GMT

Hard to say without a sample or a lot more information.

Some thoughts - the override applies to selections only. Selections in other fields could reduce the data set, including the fields in the override set selection.

If this in a nested expression, make sure that the set is applied to both the outer and inner expressions (especially for constructs like Sum(Aggr(...))

Re: Set Analysis Not Responding to Filters

etrotter — Fri, 17 Nov 2017 04:46:25 GMT

I am using it in a bar chart to make a goal line by using the reference line, here is the whole expression:

=num(SUM({$<VALUE-={0},Year=,Month=,WeekNum=>}Department_Goal),'#,##0.000')

Re: Set Analysis Not Responding to Filters

jonathandienst — Fri, 17 Nov 2017 05:05:59 GMT

Nothing special here. I suggest that you upload a small sample that illustrates your problem. What field(s) are the users selecting?

Re: Set Analysis Not Responding to Filters

luismadriz — Fri, 17 Nov 2017 05:13:27 GMT

Is this one really changing or is it the other measures in the bars?

Re: Set Analysis Not Responding to Filters

woshua5550 — Fri, 17 Nov 2017 06:00:38 GMT

what is the dimension of your chart ?

this matter may happen when you use a calculated dimension

attach your app if possible

Re: Set Analysis Not Responding to Filters

sasiparupudi1 — Fri, 17 Nov 2017 15:02:31 GMT

May be try without the VALUE-={0} to see if the selection still getting influenced by the time selections?

=num(SUM({$<VALUE-={0},Year=,Month=,WeekNum=>}Department_Goal),'#,##0.000')

Re: Set Analysis Not Responding to Filters

etrotter — Mon, 20 Nov 2017 14:39:15 GMT

I ended up going into the back end and creating a new field that wouldn't respond to date as opposed to using the goal line