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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
jakobjensen
Contributor II
Contributor II

Get top 10 of dimensions based on variable

Say I have three features: "gender", "age" and "total_purchase".

 

I want to create a bar-chart of the  "median(age)" for each "gender" based on the top N "total_purchase". the top-N total purchase should be an input e.g a slider, that can be changed.

I have created a variabel "top_freq" and an "input-box" for it. But it seems like when I set "limit" as ">= $(top_freq)" it says "calculated on median(age)" i.e I think it takes the top 10 "median age" - I don't want that, I want it to give me the median age for each gender ("F","M") based on the top 10 (or 20, or 15) "total_purchase".

 

Is that doable?

Labels (1)
1 Reply
anat
Master
Master