Greater Than

[dylannelson]

Hello,

I'm trying to get this chart to show all records that has (<=40 Hours)

[sibin_jacob]

I am assuming Hours is your dimension in the chart.

Please change the dimension like below.

if(Hours<=40,Hours)

Then Check on the Suppress when value is null

[vishsaggi]

Or may be try like

= Aggr(IF(Hours<=40, Name), Name)

Suppress when value is null for this dimension.

[sunny_talwar]

Is Hour a field or a calculation check? You can try this as a set analysis like this

If it is a calculation

Sum({<Name = {"=Sum(Hours) <= 40"}>}Units)

If it is a field

Sum({<Hours =  {"<=40"}>}Units)

[dylannelson]

Hello All,

Thanks for helping I've tried all the formulas, and I still haven't figured it out. The images below are the current dimensions, and fields selected. Oh and I forgot to say..... I'm a noob, I've only been working with Qlik for a couple of weeks.

Thanks,

[sunny_talwar]

May be use Name as dimension and this expressions

Sum({<Hours =  {"<=40"}>}Units)

Sum({<Hours =  {"<=40"}>}Hours)

Sum({<Hours =  {"<=40"}>}Units)/Sum({<Hours =  {"<=40"}>}Hours)