Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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.

Highlighted

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)

Highlighted
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

Highlighted

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)