topic Re: Filter Selection is Not working to Set Analysis Condition. in QlikView

Filter Selection is Not working to Set Analysis Condition.

Vinod — Sat, 16 Nov 2024 01:22:23 GMT

Hi All,

Filter selection not working to Set Analysis Condition.

=Avg({$<[BP Repair Type]={'Heavy','Medium'},[BP Lead Time DEX] ={"<100"}>} [BP Lead Time DEX]) + Avg({$<[BP Repair Type]={'Super Light','Light','Grooming'},[BP Lead Time DEX] ={"<50"}>} [BP Lead Time DEX])

Filter is

BP Repair Type

Grooming

Heavy

Light

Medium

Super Light

Thanks

Vinod.

Re: Filter Selection is Not working to Set Analysis Condition.

Vegar — Mon, 03 Feb 2020 07:24:51 GMT

What are you trying to do?

Your set expressions are created in such a way that any selection to <[BP Repair Type] will be ignored.

Re: Filter Selection is Not working to Set Analysis Condition.

Vinod — Mon, 03 Feb 2020 08:38:06 GMT

Please Suggest How to write the expression which has to be change based on the Filter selection.

Re: Filter Selection is Not working to Set Analysis Condition.

Vegar — Mon, 03 Feb 2020 08:42:34 GMT

How should it affect your expression?

What should happen when selecting 'Heavy' and 'Light' or when you're only selecting 'Grooming'?

Re: Filter Selection is Not working to Set Analysis Condition.

Vegar — Mon, 03 Feb 2020 08:48:46 GMT

You could try this adjustment? It will only calculate for the selected repair types that intersect with your modifiers.

=Avg({$<[BP Repair Type] *= {'Heavy','Medium'},[BP Lead Time DEX] ={"<100"}>} [BP Lead Time DEX]) + Avg({$<[BP Repair Type] *= {'Super Light','Light','Grooming'},[BP Lead Time DEX] ={"<50"}>} [BP Lead Time DEX])

Is this what you are looking for?

Re: Filter Selection is Not working to Set Analysis Condition.

Vinod — Mon, 03 Feb 2020 09:03:08 GMT

I am trying to find out the Average of [BP Lead Time DEX] for [BP Repair Type]-->Heavy and Medium and [BP Lead Time DEX] less than 100 for Heavy and Medium same
for [BP Repair Type] -Super Light, Light, Grooming and [BP Lead Time DEX] less than 50 for Super Light, Light, Grooming,

If i Select [BP Repair Type] filter it should change accordingly.

Re: Filter Selection is Not working to Set Analysis Condition.

jonathandienst — Mon, 03 Feb 2020 09:51:38 GMT

>>If i Select [BP Repair Type] filter it should change accordingly.

That's the $64k question.... If Vegar's solution is not working for you, then you need to be more specific about what should happen the selections that you might make. Is should change precisely how?