Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Vinod
Creator
Creator

Filter Selection is Not working to Set Analysis Condition.

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. 

Labels (1)
6 Replies
Vegar
MVP
MVP

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.

 

Vinod
Creator
Creator
Author

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

Vegar
MVP
MVP

How should it affect your expression? 

=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])

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

Vegar
MVP
MVP

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?

Vinod
Creator
Creator
Author

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.

jonathandienst
Partner - Champion III
Partner - Champion III

>>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?

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein