Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Kylerose9
Contributor
Contributor

Median Case When

I'm trying to have my table calculate the median order value, but only when orders are greater than £0. How would I set up my formula to do this?

1 Reply
mato32188
Specialist
Specialist

Hi @Kylerose9 ,

try something like this:

median( { < yourField = {">0"} > } yourField)

or

median( { < yourField = {"=sum(yourField)>0"} > } yourField)

Thanks.

br

m

ECG line chart is the most important visualization in your life.