Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Iwin
Partner - Creator
Partner - Creator

Any object to use measure as a filter

Hi 

I want to use below measure to filter top 10 materials upon selection

sum(aggr(if(rank($(vWMAPEtotal)*100 *sum(
Aggr($(vDerivedErrorValue),[Country key TEXT],Material,[Forecast Accuracy Period],[Profit Center]$(vRadio_Button)))/
sum( total Aggr($(vDerivedErrorValue),[Country key TEXT],Material,[Forecast Accuracy Period],[Profit Center]$(vRadio_Button))))
<=10
,$(vWMAPEtotal) *sum(Aggr($(vDerivedErrorValue),[Country key TEXT],Material,[Forecast Accuracy Period],[Profit Center]$(vRadio_Button)))/
sum( total Aggr($(vDerivedErrorValue),[Country key TEXT],Material,[Forecast Accuracy Period],[Profit Center]$(vRadio_Button))))
,[Material Code]))

 

As it a complex measure i cannot create at backend.Also tried using aggr but it is giving incorrect values.

How can i give the user top10 only on selection ?

Labels (1)
1 Reply
Andrea_Bertazzo
Support
Support

Hi @Iwin 

Could you, please, better explain what you need to get?

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up ! 🙂