Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Greater Than


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


5 Replies
Creator III
Creator III

I am assuming Hours is your dimension in the chart.

Please change the dimension like below.


Then Check on the Suppress when value is null

Champion III
Champion III

Or may be try like

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

Suppress when value is null for this dimension.

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)

Contributor II
Contributor II

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.




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)