Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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 ! 🙂