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
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
klaus_feldam
Creator II
Creator II

Leave 0 values out of c calculation

A really simple question about using the FirstSortedValue calculation... I am almost embarrassed to ask such a simple question, but I have never used this function before.

Basically, I only want to consider values in the BMI column greater than 0.

See attached table.

Screen Shot 2020-09-14 at 3.02.40 PM.png

 

 

Labels (2)
1 Solution

Accepted Solutions
jwjackso
Specialist II
Specialist II

Try something like FirstSortedValue({<BMI={">0"}>}BMI,[Date])

firstsortedvalue.PNG

View solution in original post

3 Replies
jwjackso
Specialist II
Specialist II

Try something like FirstSortedValue({<BMI={">0"}>}BMI,[Date])

firstsortedvalue.PNG

View solution in original post

Kushal_Chawda

@klaus_feldam  how about this if you uncheck below option?

Screenshot 2020-09-14 231330.png

klaus_feldam
Creator II
Creator II
Author

Tada! Thank you very much.