Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

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

Greater Than

Hello,

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

QlikExample.PNG

5 Replies
Creator III
Creator III

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

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.

Thanks,

QlikExample1.PNG

QlikExample2.PNG

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)