topic Re: Greater Than in QlikView

Greater Than

dylannelson — Tue, 07 Aug 2018 21:33:56 GMT

Hello,

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

Re: Greater Than

sibin_jacob — Tue, 07 Aug 2018 23:58:48 GMT

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

Re: Greater Than

vishsaggi — Wed, 08 Aug 2018 00:13:56 GMT

Or may be try like

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

Suppress when value is null for this dimension.

Re: Greater Than

sunny_talwar — Wed, 08 Aug 2018 02:47:26 GMT

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)

Re: Greater Than

dylannelson — Wed, 08 Aug 2018 13:59:36 GMT

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,

Re: Greater Than

sunny_talwar — Wed, 08 Aug 2018 17:36:10 GMT

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)